Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 🙂