Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
I have multiple values in one columnA like a, b, c, d and I would like to create a new columnB where I say
if columnA value contains[a,b,c ] then ColumnB = "1" and if Contains [f,g,h] then ColumnB = "2"
How can I write this DAX? I can do by IF and OR but that seems to be too long. is there any other keyword which can help me here. thanks
Solved! Go to Solution.
A SWITCH ( TRUE, .., ) is useful here.
ColumnB =
SWITCH (
TRUE (),
[ColumnA] IN { "a", "b", "c" }, "1",
[ColumnA] IN { "f", "g", "h" }, "2"
)
Note: I'm not sure I'm interpreting "columnA value contains[a,b,c ]" correctly though. Can you clarify?
A SWITCH ( TRUE, .., ) is useful here.
ColumnB =
SWITCH (
TRUE (),
[ColumnA] IN { "a", "b", "c" }, "1",
[ColumnA] IN { "f", "g", "h" }, "2"
)
Note: I'm not sure I'm interpreting "columnA value contains[a,b,c ]" correctly though. Can you clarify?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
88 | |
86 | |
68 | |
51 | |
32 |
User | Count |
---|---|
126 | |
112 | |
72 | |
64 | |
46 |