Forum Discussion
Scenario Building using What if parameter
Anonymous everything is dynamic in this solution, as data changes, everything will work accordingly.
Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Anonymous solution is attached, there are two tables, TierInput and TierRange and in the TierInput table, I added a new column for Tier
Tweak the solution as per your needs.
Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
parry2k i think you have unpivoted the columns for %rate in tier range correct ? The %rate is static values, however it should be dynamic, like a bin that should fall under those tier ranges given dynamically. How can i achieve that? For eg: if i select a product with certain rate 40% for the year 2020, the tier is 3, what if i change my rate to the next year from 40 to 80% then it should dynamically give tier 5 for that particular product .