Forum Discussion
Solved
Conditional Column in M using another table as a reference
Basically, If this description column contains anything in a seperate reference table I have e.g. Reference Lookup table TYE COP HAE NOP WEP Then True Else False So basically ...
DebbieE see attached, there are two tables, "search and replace" table is the one used for dynamic replace, it will search the text in "search" column (regardless of length) and replace the value from "replace" column
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
