Forum Discussion

sccoleman1189's avatar
sccoleman1189
Icon for Helper I rankHelper I
7 years ago
Solved

Change value based on value in other column

New to the Power BI world..

 

I am looking to create a new column that takes the value from another column if the column has a specific value.

 

Example:

 

If the home_station column has the name XYZ I would like my new column to return the value from the work_station. If the value is not XYZ, then I want to keep the value from from home_station. Please see example below

 

 

Need Help
  • Diegoctn's avatar
    Diegoctn
    7 years ago
    Column = if(PBI_Report[HOME_STATION]="XYZ",PBI_Report[WORK_STATION],PBI_Report[HOME_STATION])
     
    Just change the PBI_Report with your report's name. 

3 Replies

  • Diegoctn's avatar
    Diegoctn
    Frequent Visitor
    7 years ago
    Column = if(PBI_Report[HOME_STATION]="XYZ",PBI_Report[WORK_STATION],PBI_Report[HOME_STATION])
     
    Just change the PBI_Report with your report's name. 
    • sccoleman1189's avatar
      sccoleman1189
      Icon for Helper I rankHelper I
      7 years ago

      Thank you. Now, one question, if there are multiple values I want to change do I include "and,if" and if so how do I set that up? Been working on that and its not working

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        HI sccoleman1189,

         

        Maybe you can try to use 'in' operator to handle multiple values.

        OR Condition=
IF (
    PBI_Report[HOME_STATION] IN { "XYZ", "MNO" },
    PBI_Report[WORK_STATION],
    PBI_Report[HOME_STATION]
)

AND Condition =
IF (
    PBI_Report[HOME_STATION] = "XYZ"  && PBI_Report[BU] = "XXX",
    PBI_Report[WORK_STATION],
    PBI_Report[HOME_STATION]
)

         

        Reference links:

        The IN operator in DAX

         

        Regards,

        Xiaoxin Sheng