Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I have the following simple table. How do you create a measure for RUNNING TOTAL that is based on date column? Thanks.
I will have a date slider.
For example, if I select January 3-5, I will see only this
Solved! Go to Solution.
Use this formula when calculating running total measure
Running Total = Calculate ( SUM('sample'[QTY]), FILTER( ALL('sample'[Date ]),'sample'[Date ] <= MAX('sample'[Date ])))
See the sample below for a visual with running total column
Hope it helps.
Although I'm quite confdent with DAX I still use the power BI built in measure for running totals. You can't go wrong. Instead of selecting measure, select 'New Quick measure' a few items down. Go down to Running Total on the list. add the desired columns - manipulate the DAX where required. I often add other variables which only start showing data when it's revelant etc.
Are you summarizing the QTY column ?
This is with out QTY summarised
This is with
So recheck what is happening to your fields.
Share sample pbix file to help you.
Use this formula when calculating running total measure
Running Total = Calculate ( SUM('sample'[QTY]), FILTER( ALL('sample'[Date ]),'sample'[Date ] <= MAX('sample'[Date ])))
See the sample below for a visual with running total column
Hope it helps.
Hi @HaneeshaThan ,
Thank you very much for your quick reply. Unfortunately the formula does not work. I am getting the same Running Total as the QTY. Any ideas? Thanks again.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
102 | |
98 | |
89 | |
70 |
User | Count |
---|---|
166 | |
131 | |
129 | |
102 | |
98 |