Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
So I have looked around on the interweb but can't find what I need.
I need to replace a line of text like "Supermarket jada jada accounting stuff happy day" with the value "Food and Drinks".
The focus here is on supermarket, when this word is in the text it should replace the whole text with the value "Food and Drinks"
I got it to the point that it replaces the word Supermarket with Food and Drinks. But I need the whole text to be replaced.
Found some DAX code that uses "using CONTAINSSTRING" but I can't get it to work.
Suggestions are very welcome.
Solved! Go to Solution.
Hi @efeurich
Please try the following:
my sample table created in power query and loaded into the data model:
Calculated Column:
Formula to replace the string:
ReplaceText =
IF(
CONTAINSSTRING([Text],"supermarket") = TRUE(),
"supermarket",
[Text]
)
Result:
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Hi Micheal,
Thanks for the clear and effective explanation.
Best regards,
Eric
Hi Eric,
I am happy to help! Thank you for your feedback!
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Hi @efeurich
Please try the following:
my sample table created in power query and loaded into the data model:
Calculated Column:
Formula to replace the string:
ReplaceText =
IF(
CONTAINSSTRING([Text],"supermarket") = TRUE(),
"supermarket",
[Text]
)
Result:
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.