Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
If I am selecting the current year then it will show last two year data and If not slect any year then it will show only curent and last 2 years data please help thanks in advance
Reason code | 2021 | 2022 | 2023 |
England | 33% | 27% | 11% |
China | 21% | 46% | 13% |
India | 55% | 31% | 16% |
America | 44% | 78% | 17% |
@sudeep_92 You can build that logic into your measure using similar logic to this: The Complex Selector - Microsoft Fabric Community. Would need to know more about your source data to be more specific.
Hi thanks for your responce but your dax is not working for me may be in near future it will help a lot.
I am sharing my current data with you.
RGN | Year | Actual Demand | Actual forecast | Mape% |
APAC | 2020 | 230 | 250 | 87% |
NA | 2020 | 234 | 200 | 29% |
Europe | 2020 | 450 | 456 | 22% |
APAC | 2020 | 650 | 560 | 55% |
NA | 2021 | 720 | 600 | 61% |
Europe | 2021 | 456 | 500 | 41% |
APAC | 2021 | 657 | 768 | 11% |
NA | 2021 | 345 | 413 | 77% |
Europe | 2022 | 543 | 500 | 29% |
APAC | 2022 | 876 | 789 | 22% |
NA | 2022 | 546 | 600 | 55% |
Europe | 2022 | 298 | 300 | 81% |
APAC | 2023 | 123 | 150 | 61% |
NA | 2023 | 765 | 750 | 41% |
Europe | 2023 | 345 | 400 | 31% |
APAC | 2023 | 786 | 900 | 43% |
In this data I want a DAx that if I select a current year from slicer then it is showing the data with current year and two previous year (i.e. select year is 2023 then data is comming like 2023, 2022 and 2021) and in this table i want to show Mape% year wise with RGN coloum.
Thanks in advance if you help me out 🙂
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.