Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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?
User | Count |
---|---|
84 | |
75 | |
73 | |
42 | |
36 |
User | Count |
---|---|
114 | |
56 | |
52 | |
43 | |
42 |