Forum Discussion
Solved
Switch True
I need help with the Switch True Measure. If supplier is 123456 then return "preferred" else "non preferred". Table 1 Supplier 123456 12322 13123 2313123 123122 2312 ...
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")
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")