Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
PowerrrBrrr
Helper III
Helper III

Using IF statement in Power Bi

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

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

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?

View solution in original post

1 REPLY 1
AlexisOlson
Super User
Super User

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?

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.