Can you please help me on the below issue.
I have the data and i have the year details in the slicer. I have the logic for calculating the current year's Q1 value.
Solved! Go to Solution.
Just remove the current filter on TEST_REPORT[CY Year] with the ALL function and set a new one to last year. In your logic, it should look like this:
SUM(TEST_REPORT[Amount in local cur.],
TEST_REPORT[CY YEAR] = TEST_REPORT[YEAR] - 1
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
Proud to be a Datanaut!
Hi @Swamy3105 ,
Can you share the solution? Thanks in advance.