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 |
| 13123123 |
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")
1 Reply
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")