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
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

jracer007,

 

The first parameter <result_columnName> of LOOKUPVALUE Function needs to be the name of an existing column that contains the value you want to return.

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

I do not understand.

  • Stachu's avatar
    Stachu
    Icon for Community Champion rankCommunity Champion
    8 years ago

    I still thik you should follow Greg_Deckler idea and change it in PowerQuery. Instead of LOOKUPVALUE in DAX you can merge the tables using Table.NestedJoin in PowerQuery, it should give the same end result and you have much more flexibility in transforming the tables

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

      With a custom column can I use PowerQuery?

      • 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