Question: how to calculate the difference in power bi?
Answer: Accumulated Difference = VAR Current_Index = MAX ( Data[Index] ) VAR Initial_Amount = CALCULATE ( MAX ( Data[Amount] ), FILTER ( ALL ( Data ), Data[Index] = 1 ) ) VAR Accumulated_Reductions = CALCULATE ( [Total Amount], FILTER ( ALL ( Data ), Data[Index] > 1 && Data[Index] <= Current_Index ) ) RETURN Initial_Amount - ...