Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to Solution.
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")
Proud to be a Super User!
Paul on Linkedin.
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")
Proud to be a Super User!
Paul on Linkedin.
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |