Forum Discussion

RDA_PowerBI's avatar
RDA_PowerBI
Frequent Visitor
7 years ago
Solved

Calculate Difference Between Previous Row

Hi,   I am looking for help calculating the difference between the Numbers column below if  'Table'[Book] = EARLIER ('Table'[Book]) . The column below is what I would need. This would help determin...
Need Help
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    Right, so you would subtract the numbers. The intention was to show you how to use MAXX/MINX coupled with EARLIER and other filters to figure out the previous row value that you want to target and then you can use that to calculate what you want.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Try this calculated column formula

 

=if(ISBLANK(CALCULATE(MAX(Table1[Numbers]),FILTER(Table1,Table1[Book]=EARLIER(Table1[Book])&&Table1[Numbers]<EARLIER(Table1[Numbers])))),BLANK(),[Numbers]-CALCULATE(MAX(Table1[Numbers]),FILTER(Table1,Table1[Book]=EARLIER(Table1[Book])&&Table1[Numbers]<EARLIER(Table1[Numbers]))))

 

Hope this helps.

 

ahsankhan's avatar
ahsankhan
Helper I
6 years ago

Hey thank you for your reply. Is it possible to have a calculated measure for this scenario. As the data i have to deal with contains so many rows and with calculated columns it takes alot of time. And our basic necessity is to reduce the time for the reporting. 

 

Thank you