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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Balhemkan
Helper III
Helper III

Understanding dax

Hi everyone, 

 

I want to learn how cumulatives work and step by step explanation of measures(dax).Could someone help me with video's or blogs.

Because in YouTube and blog's I can see how we can write formulas but I'm not sure how it will work. I mean how powerbi will understand measures. How we can make powerbi understand easily. 

Can someone suggest me with tips and tricks. 

 

 

 

1 REPLY 1
MattAllington
Community Champion
Community Champion

You are asking a very broad question. It's like saying, can you tell me how planes fly without flapping, and how can I fly one. There is a lot to learn. One of the first things you must understand is that Power BI is a database, not a spreadsheet. Storage of data in a database does not have a stored order. It therefore follows that you can't create a cumulative total "down the page" because there is no "order" to "follow".  You need to filter the database so it calculates a total up until a set ID (eg a date). When you lay those IDs out in order, it mimics a running total. 

i have an article here about time intelligence here. It's not quite the same as cumulative totals, but the concept is the same. https://exceleratorbi.com.au/dax-time-intelligence-beginners/



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.