Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
226 | |
129 | |
120 | |
84 | |
78 |