Tag: Monthly Average

Cumulative Totals Across Averages & Dynamic Date Logic – Advanced DAX

Cumulative Totals Across Averages & Dynamic Date Logic - Advanced DAX

Today I wanted to cover a unique technique around cumulative totals inside of Power BI. Usually, when we are reviewing cumulative totals we are analyzing them over a date or over a month and year. What we are going to do here though, is we’re going to analyze them versus the month. This particular example

Continue reading

Average Results Per Month – DAX & Power BI Analysis Technique

In this video tutorial, I dive into some procurement & purchasing type analysis that you can do with Power BI. Specifically, we’re going to look at the average monthly purchases a business may be making. I run through what DAX formula combination you need to be able to calculate averages at a monthly context. I

Continue reading