Forum Discussion

perishkabb's avatar
perishkabb
New Member
5 years ago
Solved

If statement based on another column

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!!!

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    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 🙂 

     

  • v-luwang-msft's avatar
    v-luwang-msft
    5 years ago

    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

3 Replies

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    5 years ago

    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's avatar
    Anonymous
    Not applicable
    5 years ago

    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 🙂