computaz

Catch up on what's happening in the Office 365, Azure and general Microsoft Community today. Vote up your favorites and add your own.

I am still struggling with a line chart that shows monthly year to date totals in a line chart, with the last 3 years graphed.   Management wants something that looks like this....   I am using a financial date table with fiscal year, fiscal month beginning on Nov 1 and end Oct 31.  I can get PBI t...

In this article we look at how to visualize data in Power BI by week of quarter. We walk through the steps on how this can be done in a Power BI report.

Articles and whitepapers about BI technologies from renowned experts and book authors.

In this Power BI Blog post, I show you how to append text to the end of all your column names in Power Query

This video focuses on how to return value based on the most recent date. Previous Content Trick to connect to .asp website using Web in Power Query - https://www.youtube.com/watch?v=aWV_FlzB3n0 #01 Dynamic Text and Headings with Dax in Power BI - https://www.youtube.com/watch?v=iQc_B... #02 Dynamically Change Colors with Dax in PowerBI Part 1 - https://www.youtube.com/watch?v=mprMk...

ADDCOLUMNS: Returns a table with new columns specified by the DAX expressions. https://dax.guide/addcolumns/

- - - - My Courses - - - -✔️ Mastering DAX in Power BI -https://goodly.co.in/learn-dax-powerbi/✔️ Power Query Course-https://goodly.co.in/learn-power-query/✔...

This article describes the DAX filter context using a conceptual model based on a visual representation. The filter context is a fundamental concept to unde

Need to learn how to smooth data in Excel? Then, you've come to the right place. Here, we'll show 6 easy ways of it with proper illustration.

In Power Query, you can group or summarize the values in various rows into a single value by grouping the rows according to the values in one or more columns. Power Query has two types of Group By operations: aggregate a column with an aggregate function, or perform an operation.

while adding an app to teams received something went wrong message

There are some reports where I have a schedule refresh but I also want to bring in new data whenever I happen to be looking at the report. Or a report where only want to refresh it on demand. This is where Power Automate can really be useful!Before we start:Before you do this, you will need to have created a report and published it the Power BI Service (to your "My workspace" or other created workspace). And after published, go to the Scheduled Refresh window (Workspace Datasets and dataflows

By default, Microsoft Word does not display all the built-in styles on the Home tab or on the Styles pane.

This article describes how to compare time series that occur in different periods by standardizing the timelines to days since a specific event. In a previo

I showed you on last monday's video: https://www.youtube.com/watch?v=uX3_dnb5on0 how to do running totals in power query, and in this video I will show you h...

In today's video I will show you how to fill up or down based on conditions. I am going to show you two ways to do it, you pick the one need :)Chapters00:00 ...

Learn how to create a dynamic calendar table in Power Query's M language. Build your custom columns and claim your free Date Table Script.

Make background transparent or fill it with any color

Use this plug-and-play workflow to send new events in Notion to your Google Calendar.

How can you create a date table with monthly intervals? This technique achieves it with ease. WRITTEN ARTICLEhttps://gorilla.bi/power-query/date-table-with-m...

Learn how to configure Domain-based Message Authentication, Reporting, and Conformance (DMARC) to validate messages sent from your organization.

Learn how to update a Domain Name Service (DNS) record to use Sender Policy Framework (SPF) with your custom domain in Office 365.

Learn the theory and best methods to create a dynamic sensitive outlier detection and customize it to your particular dataset. Please find the data set and d...

Learn the difference between the two important DAX functions; DatesInPeriod and DatesBetween using samples

A question that we are often asked is this; can you put a measure into a Slicer?

This video compares SUM to the SUMX function in DAX. What are the similarities between SUM and SUMX, how are they different and I provide some measure exampl...

This article explains a typical pattern to optimize a SUMX iterator by reducing the number of callbacks in the expression. Pushing calculations down to the