Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 🙂
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
69 | |
61 | |
18 | |
16 | |
13 |