Forum Discussion
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...
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 ||
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 ||