Forum Discussion

Suhel_Ansari's avatar
Suhel_Ansari
Helper V
6 years ago

Adding previous Rows values

Hi All, Hey DAX Expert i need your help in measure to calculate the value i have 3 measure as mentioned below.  First Measure = "1 Registration" Second Measure = "1 Termination" Third Measure = "...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Suhel_Ansari , You can this year and last year values like this, make sure you have YEAR in separate Table or Date Table

 

This Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])))
Last Year = CALCULATE(sum('order'[Qty]),filter(ALL('Date'),'Date'[Year]=max('Date'[Year])-1))

 

With help of this you can create other calculations