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...
Hi, BjoernSchaefer
try this
Difference =
CALCULATE(
SUM('Data'[value]),
FILTER(
ALL('Data'),
'Data'[row] = EARLIER('Data'[row]) - 1
)
) - 'Data'[value]
the code will only work if your row column has unique value. If not then create an index column starting from 0.
If you have missing values in your value column then try this: make sure you have an index column starting from0
Difference =
LOOKUPVALUE (
Data[value],
Data[Index],
Data[Index] - 1,
BLANK ()
) - Data[value]
this thread might help:
Solved: I need output like this by using measure ( calcula... - Microsoft Fabric Community
frankly Or you can use IF statememnt:
Difference =
IF(
Tabelle[row] = 1,
BLANK(),
(LOOKUPVALUE(Tabelle[value], Tabelle[row], Tabelle[row] - 1) - Tabelle[value]) * -1
)