Forum Discussion
Check Range in 2 Columns and get required output value
Hi Guys Please guide the query or way out to get the required output in Power BI Thanks in advance Funding % Winning % Required Output 100 100 High 100 75 High 100 50 ...
Hi, Anonymous
You can try the following methods.
Column = SWITCH(TRUE(), [Funding %]>=75&&[Winning %]>=75,"High", [Funding %]>=50&&[Winning %]>=50,"Med", "Low")Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much
ribisht17
Super User
Super UserYou are welcome although I did not see you marking the answer :), but I guess it helped you.