Forum Discussion
Continuous Subtracting Previous Row
Hi,
I was wondering how to continuously subtract from a previous row and have a continuous remainder that the row subtracts from.
For example in the screenshot, the total originally was 254. I want to then subtract the 99, and for the previous row I want the total to change from 254 to (254-99)=155, and then the top row of (155-22)=133.
Is this possible?
Thanks!
Sarah
Anonymous , you need to have index or date column - https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
then a new column like
Col 3= [Col1] - sumx(filter(Table, [Index] <= earlier([Index])) ,[Col2])
1 Reply
Anonymous , you need to have index or date column - https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
then a new column like
Col 3= [Col1] - sumx(filter(Table, [Index] <= earlier([Index])) ,[Col2])