Running Total

[vasathi]

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

[Padycosmos]

Hope this video helps:

https://www.youtube.com/watch?v=y7ucCjtADsg&t=16s

[vasathi]

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

[amitchandak]

@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-bd52912a5b...
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.

[vasathi]

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

[vasathi]

Still showing Wrong.

please help me...