Forum Discussion

Abdullah-Ultra's avatar
Abdullah-Ultra
Frequent Visitor
2 years ago
Solved

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 ...
Need Help
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, Abdullah-Ultra 

     

    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.

     

ribisht17's avatar
ribisht17
Icon for Super User rankSuper User
2 years ago

Please mark the answer and help the community in return if it helped or else let us know