See attached Sample File
I am trying to dynamically calculate the last 12 months from the selcted month on the slicer.
Go to Solution.
Can you please try the below dax function
VAR CurrentDate = SELECTEDVALUE(‘Date'[End of Month Date],MAX(‘Date'[End of Month Date]))
VAR PreviousDate = CurrentDate – 365
Table[End of Month Date] >= PreviousDate && Table[End of Month Date] <= CurrentDate
View solution in original post
Hi Nitesh. The measure is not working, can you kinldy test uing the Sample file.
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.