Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Find articles, guides, information and community news

Most Recent
GilbertQ
Super User
Super User

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

Read more...

EnterpriseDNA
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

Read more...

Helpful resources

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