Forum Discussion
Running Total
Team
I'm creating a sample report, to show the running total. Below dax is working fine
After adding some other dimension then the Running total is not showing as expected
What could be the reason and help me to fix this. i'm sure someone might faced this issue before.
Regards
5 Replies
vasathi , refer if Windows function can help
Continue to explore Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
or try a measure like this with help from date table
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date])))
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.Still showing Wrong.
please help me...Dear amitchandak
This link also provides same result. All demos are using one column only, the problem is when i use multiple column then i'm not getting the expected result.
Regards
Dear Padycosmos @amitchanda
This link also provides same result. All demos are using one column only, the problem is when i use multiple column then i'm not getting the expected result.
Regards
