-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 9-
(Excel formulas also welcome)
There is a table which has Original Text and there is another table which contains the list of words which need to be replaced.
After replacement, output should look like Result.
Updated on the basis of comments - To provide further clarity
- It is word to word replacement. Hence, cat should be changed to Cat only if it finds cat not cats or catastrophe.
- To keep problem simple, let’s limit punctuation marks to only comma, dot and apostrophe. For example
cat,
cat.
cat’s
The practice file has been updated with these test cases. Hence, there will be little difference between picture posted here and practice file.
Download Practice File - https://lnkd.in/dhsPtavC
(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)
#powerbi, #powerquery, #dax, #powerquerychallenge, #powerbichallenge, #powerqueryproblem, #powerbideveloper, #powerbidesktop, #powerbitips, #powerbitricks, #excel, #excelchallenge, #excelproblem, #powerpivot
Excel BI’s LinkedIn Post