Tag: SUMMARIZE

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

How To Calculate Actual Results To Budgets Per Product – Power BI & DAX

How To Calculate Actual Results To Budgets Per Product - Power BI & DAX

In this advanced video tutorial which is a breakout of a budgeting workshop that was part of the Enterprise DNA webinar series, I am going to run through how you can utilize some advanced functions inside of Power BI like CALCULATE, ALLSELECTED and SUMMARIZE. By using all the functions in combination we are able to

Continue reading