replace text based on another column
1 Topic
Replace/Substitute text in specific column using DAX
I need to replace a text in a specific column, but as my report comes from a cube, I cannot manipulate the data using Power Query or Add Columns, the only option I have is to create a measure using DAX. I did a research and I could use Replace or Substitute, but I'm still not quite sure how to replace a text every time it appears in the column. Below is an example in excel of what I'm looking for to do in PBI. In this example, I need to substitute/replace Apple for Pear. Original Names NEW Names Apple Pear Banana Banana Strawberry Strawberry Apple Pear Banana Banana Strawberry Strawberry Strawberry Strawberry Strawberry Strawberry Banana Banana Banana Banana Apple Pear Banana Banana Apple Pear Apple Pear Strawberry Strawberry Apple Pear Banana Banana Strawberry Strawberry Strawberry Strawberry Strawberry Strawberry Banana Banana Banana Banana I appreciate any help. Thanks!Solved11KViews0likes4Comments