Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

Most Recent
Super User
Super User

This blog post details how to get the right date format shown in the Power BI Service


Kudo Kingpin
Kudo Kingpin

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, CALCULATEFILTERand MAX. Here, I calculate the cumulative total revenue for a certain year and quarter, which requires the ALLSELECTED function. 


running totals vs cumulative totals.png


Helpful resources

Join Blog
Interested in blogging for the community? Let us know.