Forum Discussion
Solved
Replacing a substring with selected value
Hello, I'm creating a personalized letter in Power BI desktop (have to do it using this, because of client's demand...). I have a customer table (lets say it has only 2 columns: custID and custN...
Thank you for the clear explanation. Calculated columns do not communicate with the filter context. This has to be a measure
calcCustSubstitute =
SUBSTITUTE (
SELECTEDVALUE ( Phrases[phrase] ),
"[custName]",
SELECTEDVALUE ( customers[custName] )
)
Thank you for the clear explanation. Calculated columns do not communicate with the filter context. This has to be a measure
calcCustSubstitute =
SUBSTITUTE (
SELECTEDVALUE ( Phrases[phrase] ),
"[custName]",
SELECTEDVALUE ( customers[custName] )
)
Thank you very much, tamerj1 .
Now it works like a charm.