Forum Discussion

rayinOz's avatar
rayinOz
Icon for Helper III rankHelper 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 ot...
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

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