If statement based on another column

[perishkabb]

Hello,

I'm new to Power BI and I have no idea what I'm doing 🙂

I have a column with program code (QI05, QI10, QI26, various, etc.) and a column with organizational code (R091, R092, R093 etc).

If program code is = QI41 and/or 41IRSA then the column for org.code must change to R091-RT.

If program code is = QZ09 and/or 40IRSA then the column for org.code must change to R091-FT.

How do I set this up?

Thank you!!!

[Anonymous · Accepted solution]

Hi @perishkabb 

You need to add a custom column in Power Query to reflect these conditions and later delete the old column. This way you create a replacement.

Statement should be written like this:

if ([Program Code] = "QI41" or [Program Code]="41IRSA") then "R091-RT"
else if ([Program Code] = "QZ09" or [Program Code]="40IRSA") then "R091-FT"
else [Org Code]

I have recreated your case with a small sample. You can find the file in this link. 

Hope it helps 🙂 

[perishkabb]

Thank you both so much!!

[v-luwang-msft · Accepted solution]

Hi @perishkabb ,

You could use the following dax to create a new column:

org.codenew = IF('Table'[org.code]="QI41"||'Table'[org.code]="41IRSA","R091-RT",IF('Table'[org.code]="QZ09"||'Table'[org.code]="40IRSA","R091-FT",'Table'[pro.code]))

final you will get :

Wish it is helpful for you!

Best Regards

Lucien

[Anonymous · Accepted solution]

Hi @perishkabb 

You need to add a custom column in Power Query to reflect these conditions and later delete the old column. This way you create a replacement.

Statement should be written like this:

if ([Program Code] = "QI41" or [Program Code]="41IRSA") then "R091-RT"
else if ([Program Code] = "QZ09" or [Program Code]="40IRSA") then "R091-FT"
else [Org Code]

I have recreated your case with a small sample. You can find the file in this link. 

Hope it helps 🙂