Forum Discussion
Automate a Calculated Field
Hi All,
I want to automate the below calculated field "Project Status". Like, I want to provide users options to choose $5k, $10K or 5%, 10% as the options to map project as "OPEN/CLOSE". I don't want user to update the below code. I want a simple way to make the selections.
Please help me solve this problem.
Thanks,
Hammad
Hello,
One way to do this is to add a what-if parameter that they can pick from and you refer it in the measure.
check this link https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
If I answered your question, please mark my post as solution, Appreciate your Kudos👍
1 Reply
Hello,
One way to do this is to add a what-if parameter that they can pick from and you refer it in the measure.
check this link https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
If I answered your question, please mark my post as solution, Appreciate your Kudos👍