Forum Discussion
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...
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.
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.
This is awesome and if you were doing this with dates just substitue with Datediff vs the -.
Thanks again!