Calculating for cumulative and rolling totals is quite common in Power BI to analyze data trends in business. In fact, it’s one of the most highly used patterns in analyzing historical data. While the two calculations are almost the same, there’s a slight difference between them, which is related to the logic used on each.
The first tutorial will show you the basic cumulative total pattern, which includes the DAX functions, CALCULATE, FILTER, and MAX. Here, I calculate the cumulative total revenue for a certain year and quarter, which requires the ALLSELECTED function.
Read more...