If and Else Statement to use in operator

Question

Hello,

How do I use the If and else statement in Custom Column in Power BI either with similar SQL statement or DAX. I tried looking online but always I see the examples of True or False but not with such in operator and grouped.

If ([Product] in ('ABC', 'DEF', 'GHI') then ('XYZ') Else  ('UVW')

Answer 1

Hi, MeghaSree

You can use conditional column instead of a custom column.

It is similar as a custom column and easier to provide the if-else condition.

Click on the conditional column and write condition for each value in the ('ABC', 'DEF', 'GHI') in the value box and else separately.

For example.

Hope it helps!

Answer 2

Hey @Megha.

I am new to Power BI so I'm not sure of the solution, but you can try below way.

Use a dax expression to rename the column values using condition on True or false to  'XYZ' or 'UVW' after using a custom function. Maybe it will help.