Forum Discussion

jracer007's avatar
jracer007
Icon for Helper IV rankHelper IV
8 years ago

Replace Text with other text

Hello community, I want to request your help to replace the text of a Custom Column with the text of other column. Original Text: Desired text: Thank and happy year!!
Need Help
Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
8 years ago

no, you cannot use PowerQuery with DAX custom column - but you can create the same column in PowerQuery itself (so it's no longer calcuated), you can do the PowerQuery equivalent of DAX LOOKUPVALUE by using Merge Queries functionality

jracer007's avatar
jracer007
Icon for Helper IV rankHelper IV
8 years ago

And now what do I do?