DAX Variables in PowerBI-Subtracting Prior Value from Current Value of a Column
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:
VAR PreviousYears=MAX(‘YearRevenue Table'[Years])-1
in Power View.