Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am reposting this becuase I had my logic incorrect before
1. if load says "Many" the outcome should be "Many"
2. but if the count is > 1 the outcome should be "both"
3. but if the load does not = "Many" and the count is <1 then the outcome should be the load column
Load | Count | Load | Count | Outcome | |
Many | 1 | Many | 1 | Many | |
Cat | 2 | Cat | 2 | Both | |
Dog | 2 | Dog | 2 | Both | |
Car | 1 | Car | 1 | Car | |
Many | 2 | Many | 2 | Many | |
Bottle | 2 | Bottle | 2 | Both | |
Board | 1 | Board | 1 | Board | |
Phone | 1 | Phone | 1 | Phone | |
Tree | 1 | Tree | 1 | Tree |
Solved! Go to Solution.
Try
Try this:
Column =
SWITCH(TRUE(),
Table1[Load] = "Many", "Many",
Table1[Count] > 1, "Both",
Table1[Load])
Result:
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Proud to be a Super User!
Try this:
Column =
SWITCH(TRUE(),
Table1[Load] = "Many", "Many",
Table1[Count] > 1, "Both",
Table1[Load])
Result:
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Proud to be a Super User!
Try
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |