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 na...
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. 
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