Forum Discussion

ahood89's avatar
ahood89
Regular Visitor
4 years ago

Un-accumulate a set values

I have a set of finance data that I have already had to transform and combine in Power Query, including applying exchange rates.    The values are accumulated with each Period. So P1 = P1, P2 = P1+...
Need Help
AntonioM's avatar
AntonioM
Solution Sage
4 years ago

You could add a custom column

 

Periodic Revenue = 
'Table'[Measure] - MAXX(FILTER('Table', 'Table'[Period] < EARLIER('Table'[Period])), 'Table'[Measure])

 

Where Table is your table name and Period and Measure are the columns from your screenshot

 

This will work if you only have one year's data (so one set of periods 1 through 12)

 

 

made up example: