Forum Discussion
Replace Text with other text
I'll explain it to you in more detail, My data source comes from Google Analytics:
Then I create a Custom Column to extract the data I need with a lookupvalue:
This is the data source that contains the search column:
And the visualization (matrix) is this:
Now, what I need is for all that text to be replaced by this:
Note: This text is in the same table as the replacetext_3 image.
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.
- jracer0078 years ago
Helper IV
I do not understand.
- Stachu8 years ago
Community Champion
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
- jracer0078 years ago
Helper IV
With a custom column can I use PowerQuery?