Need to split cumulative revenue into the revenue by month

[montgd]

I have P&L data that is organized as such

January 2020 - 10,000

February 2020 18,000

March 2020, 31,000

I need to be able to undo the cumulative sum and get the value for each month.  So the expected result would be

January 2020 - 10,000

February 2020 - 8,000

March 2020 - 13,000 

Does anyone have any idea on how this can be accomplished?  Thanks for your help.

[dax · Accepted solution]

Hi @montgd , 

You could refer to my sample for details.

Measure = SUM(T2[amount])-CALCULATE(SUM(T2[amount]), FILTER(ALLSELECTED(T2), T2[date]=DATE(YEAR(MIN(T2[date])), MONTH(MIN(T2[date]))-1,1)))

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[montgd]

Thank you very much - that worked perfectly.

[Greg_Deckler]

Yes, you should be able to use the approach found here, seems like your exact scenario:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Revenue-Reverse-YTD/m-p/373185#M111

[montgd]

Hi Greg

Thank you for your help.  I am still having trouble with this and let me make sure I explained it right.

This is the scenario:

January = 10,000

February = 25,000 (the 10,000 from January and 15,000 from February)

March = 40,000 (the 10,000 from January, 15,000 from February and 15,000 from March).

I tried the measure you showed me but I am getting some strange numbers.  Any ideas?