cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sccoleman1189 Frequent Visitor
Frequent Visitor

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

 

 

power bi.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Diegoctn Frequent Visitor
Frequent Visitor

Re: Change value based on value in other column

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 3
Highlighted
Diegoctn Frequent Visitor
Frequent Visitor

Re: Change value based on value in other column

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 Frequent Visitor
Frequent Visitor

Re: Change value based on value in other column

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

Community Support Team
Community Support Team

Re: Change value based on value in other column

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |