Forum Discussion
Row differences using DAX (PowerBI)
¿What would be the simplest DAX formula in PowerBI to calculate row differences? I tried using EARLIER() but it cannot handle the operation at the limit (missing data): EARLIER/EARLIEST refers t...
Hey frankly,
i was able to do it with SWITCH and LOOKUPVALUE.
Maybe there's a more elegant way.
formula = SWITCH(TRUE(),Tabelle[row]=1,BLANK(),(LOOKUPVALUE(Tabelle[value],Tabelle[row],Tabelle[row]-1)-Tabelle[value])*-1)
Kind Regards
Björn