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.
Hi,
What is the most efficient way to do the following calculated column ?
If Table[Column] contains text1, text2, text3, etc then Result1 else
If Table[Column] contains text4, text5, text6, etc then Result2
Can IN function be use to calculated columns ?
I tried the following but not sure if works or I should use other function ?
The criteria should be if column contains "SC", "CON","SI" then CON else
if column contains "AO", "BPO","IO" then OUT else
"OTHERS"
Thanks!
Solved! Go to Solution.
Hello,
CON or OUT =
IF (
'_List SG'[SG] IN { "SC", "CON", "SI" },
"CON",
IF ( '_List SG'[SG] IN { "AO", "BPO", "IO" }, "OUT", "OTHERS" )
)
Best regards,
ElenaN
Hello,
CON or OUT =
IF (
'_List SG'[SG] IN { "SC", "CON", "SI" },
"CON",
IF ( '_List SG'[SG] IN { "AO", "BPO", "IO" }, "OUT", "OTHERS" )
)
Best regards,
ElenaN
Hello,
You could try something like:
CON or OUT =
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |