Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts,
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.
See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
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:
C_Q1_LY =
CALCULATE(
SUM(TEST_REPORT[Amount in local cur.],
FILTER(
TEST_REPORT,
TEST_REPORT[QTR]=1
),
FILTER(
ALL(TEST_REPORT[CY YEAR]);
TEST_REPORT[CY YEAR] = TEST_REPORT[YEAR] - 1
)
)
It's not working, I'm getting error..... 😞
Could you be a bit more specific? What error do you get?
I have found the solution, thanks Guys....
Hi @Swamy3105 ,
Can you share the solution? Thanks in advance.
Best Regards,
I just created the calendar table with DateKey and created the relationship with the main table.
Then i have created the Messure for the results.