Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |