- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Subject | Author | Posted | |
---|---|---|---|
09-10-2024 12:20 PM | |||
11-01-2024 04:41 AM | |||
10-24-2024 02:52 AM | |||
03-12-2024 02:21 PM | |||
12-04-2024 01:21 PM |