Tag: Cumulative Totals

Cumulative Totals In Power BI Without Any Dates – Advanced DAX

In this example, I’m going to show how you can create Cumulative Totals which are not over dates in Power BI. To create cumulative totals over dates inside of Power BI is not too difficult. There’s a set of formula pattern that you can utilize and reuse for whatever type of cumulative total results you

Continue reading

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

Compare Multiple Metrics Cumulatively in Power BI using DAX

I’ve previously showcased how you can compare your actual results versus your budgeted results. But, what if you also wanted to overlay some time comparison information so you’re comparing your actuals versus budget versus last year? Or perhaps versus last quarter? Or against any other time period you may want to select? In this video

Continue reading

Compare Performance vs Forecasts Cumulatively w/DAX

Showcasing results cumulatively is, in my opinion, the best way to showcase trends in your data. When comparing data versus budget or forecasts, showing the trends or divergence in trend is essential. You want to make sure you can identify when your performance is breaking down as soon as possible and by viewing this cumulatively

Continue reading

Introducing Forecasting Logic Into Your Power BI Models Using DAX

It doesn’t get more real world than the video below for an application of Power BI to provide great insight. In the example I run though here, I want to compare my actual results to my forecasted results. Not only that – I want to view these cumulatively. The cumulative totals give me a much

Continue reading