My Friend got a Scenario where he was asked to subtract the prior value from the current value of the column. I helped him by finding the Solution on the Microsoft community I did not find the correct solution on it.
I have prepared the demo for describing the solution for the problem “Subtracting Prior Value from Current Value of a Column in Power BI “
So Let`s Start!!!
Step 1: I have created a dummy table “YearRevenue Table” with columns Revenue and Years.
Step 2: Now Create a Measure in the same table and place the DAX code mention below:
Diff = VAR Currentyear= MAX(‘YearRevenue Table'[Years])
VAR PreviousYears=MAX(‘YearRevenue Table'[Years])-1
VAR CurrentValue=CALCULATE(SUM(‘YearRevenue Table'[Revenue]),’YearRevenue Table'[Years]=Currentyear)
VAR PREVIOUSVALUE=CALCULATE(SUM(‘YearRevenue Table'[Revenue]),’YearRevenue Table'[Years]=PreviousYears)
VAR result= CurrentValue-PREVIOUSVALUE
You may also like: