Solved: Switch True

gauravnarchal · ‎08-04-2022

I need help with the Switch True Measure.

If supplier is 123456 then return "preferred" else "non preferred".

Table 1

PaulDBrown · ‎08-04-2022

Assuming the supplier column is type text,
As a calculated column:

status = IF(Table[Supplier]= "123456", "Preferred", "Non Preferred")

As a measure:

status = IF(MAX(Table[Supplier]) = "123456", "Preferred", "Non Preferred")

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.