Forum Discussion

rayinOz's avatar
rayinOz
Helper III
9 years ago
Solved

Replacing text in one column based on another column

Hello,

 

In PowerBI Desktop, I am wanting to replace text in one column based on what is in another column.

 

I have a tabled called UoM-TrainMe-Report. I have a column called Division and the other column called Organisation / Portfolio.

 

Basically, if in the column [organisation / portfolio] there is XYZ, change the text in the Division column to Other.

 

Thanks guys!

 

RayinOz

Need Help
  • PowerBIUser3's avatar
    PowerBIUser3
    9 years ago

    If you don't mind creating another column you can create a calculated column and use dax.

    NewDivision = IF([organisation / portfolio] = "ZYX", "other", [Division])

     

    If you have multiple organisations / portfolios values you want to do this for you can use OR or the logical or operator symbol ||

    https://msdn.microsoft.com/en-us/library/ee634951.aspx

2 Replies

  • PowerBIUser3's avatar
    PowerBIUser3
    Frequent Visitor
    9 years ago

    If you don't mind creating another column you can create a calculated column and use dax.

    NewDivision = IF([organisation / portfolio] = "ZYX", "other", [Division])

     

    If you have multiple organisations / portfolios values you want to do this for you can use OR or the logical or operator symbol ||

    https://msdn.microsoft.com/en-us/library/ee634951.aspx

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi rayinOz

     

    Basically this has to be done in the PowerQuery.

    If you can share the data in onedrive and post the link, I can help you with the steps.

     

    Cheers

     

    CheenuSing