Accumulate into the past - reverse running total

Anything related to PowerPivot and DAX Formuale
joshua
Posts: 5
Joined: Tue May 14, 2019 3:53 am

Accumulate into the past - reverse running total

Postby joshua » Mon Dec 09, 2019 6:18 pm

Hello!

I have a pretty easy challenge but I am still struggling. I hope someone can help me.
I have the following basic table (tblChanges) in my data model:
ID - Date - Value
100 01.12.2019 5000
100 02.12.2019 5000
100 03.12.2019 5000
100 04.12.2019 5000
100 05.12.2019 5000

Now I need a measure, that sums up the total reverse.
Does anyone know how to achieve that?

There should be something like:
ID - Date - Value - Running totals
100 01.12.2019 5000 25000
100 02.12.2019 5000 20000
100 03.12.2019 5000 15000
100 04.12.2019 5000 10000
100 05.12.2019 5000 5000

I already found that approach, but it is not working:
=calculate(SUM('tblChanges'[Value]);FILTER(ALL('tblChanges');'tblChanges'[Value]>=MAX('tblChanges'[Value])))

Bernard Heymans
Posts: 34
Joined: Wed Feb 28, 2018 12:18 am

Re: Accumulate into the past - reverse running total

Postby Bernard Heymans » Mon Dec 09, 2019 7:01 pm

I made some...
measures
Attachments
Totals past .xlsx
(395.5 KiB) Downloaded 28 times

joshua
Posts: 5
Joined: Tue May 14, 2019 3:53 am

Re: Accumulate into the past - reverse running total

Postby joshua » Sat Dec 14, 2019 8:54 pm

Awesome, thanks!


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 9 guests