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.
my previous year measure is showing wrong value. Can anyone help with this ?
Note: I am not using Date table as I need the filter slicers as shown in below screenshot.
Solved! Go to Solution.
HI @Anonymous,
I'd like to suggest you to use date function to define filter range to calculate, it is hard to custom and accuracy control the nested calculation of time intelligence functions.
Time Intelligence "The Hard Way" (TITHW)
Regards,
Xiaoxin Sheng
HI @Anonymous,
I'd like to suggest you to use date function to define filter range to calculate, it is hard to custom and accuracy control the nested calculation of time intelligence functions.
Time Intelligence "The Hard Way" (TITHW)
Regards,
Xiaoxin Sheng
Hi @v-shex-msft ,
First of all, Thanks for the ref link which is helping me. But when I am trying it. I get the below visual error. Can you help me with that ?
Is there any other formula for LYTD ?
Checking on 2020 is fine. But when checking on other years give me error.
I have the same measures
Relation for FinalTable and DateTable is Many to one with Both Corss filtering.
Thanks @v-shex-msft ,
Your suggestion helped me. For the above issue, i have changed the relation of cross filter for DateTable and FinalTable Date column to Single.
Happy to learn Power bi.
Hi @v-huizhn-msft
I have seen similar post in the below link.
https://community.powerbi.com/t5/Desktop/How-to-display-sales-YTD-and-sales-last-YTD-over-years/td-p...
Mine is similar issue but On check of the year number in slicer i need to calculate YTD and also Previous year YTD.
Your suggestions will be helpfull.
I need this quick so I have tagged you. Anyone else who can help me with this will be great. Thanks in Advance.
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 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |