If and Else Statement to use in operator

+1 vote
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')
Aug 29, 2019 in Power BI by MeghaSree
• 130 points
67 views

2 answers to this question.

+1 vote

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!

answered Aug 29, 2019 by anonymous
• 32,440 points
+1 vote
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.
answered Aug 29, 2019 by anonymous
• 32,440 points

Related Questions In Power BI

0 votes
1 answer

How to Create and use doughnut charts in Power BI?

Hey, To create a doughnut chart in Power ...READ MORE

answered Feb 6 in Power BI by Gitika
• 26,030 points
93 views
0 votes
1 answer

How to Transpose unique values and get matching values in rows?

I think this query should do what ...READ MORE

answered Apr 1, 2019 in Power BI by Upasana
• 8,590 points
152 views
0 votes
1 answer

How to use Python Scripts in Query Editor?

Hi, In order to use Python Visuals you need ...READ MORE

answered Apr 10, 2019 in Power BI by Avantika
• 1,500 points
679 views
0 votes
1 answer

How To use R Integration in Power BI?

Hi,  There are a lot of packages available ...READ MORE

answered May 2, 2019 in Power BI by Avantika
• 1,500 points
380 views
0 votes
1 answer

How to show visualization (map) based on latitude and longitude points in power BI?

Follow the below steps: 1. Select the map ...READ MORE

answered Oct 17, 2019 in Power BI by anonymous
• 3,380 points
114 views
0 votes
1 answer

How to use a gateway in Power Bi?

Follow the below procedure - 1. Install ...READ MORE

answered Oct 29, 2019 in Power BI by rachael
94 views
0 votes
1 answer

How to use play axis in stocked column chart

Hey Katyvin, If you want to use the ...READ MORE

answered Feb 18 in Power BI by Gitika
• 26,030 points
76 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 21, 2018 in Power BI by nirvana
• 3,060 points
923 views
0 votes
1 answer

How to calculate cumulative Total and % in DAX?

Hi, If your table is ready with percentage ...READ MORE

answered Mar 18, 2019 in Power BI by Cherukuri
• 32,440 points
4,052 views
0 votes
1 answer

How to categorize state, pin and city in power bi (Address)

After loading dataset, you can split in ...READ MORE

answered May 9, 2019 in Power BI by anonymous
• 32,440 points
140 views