Forum Discussion
Conditional Column in M using another table as a reference
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.⚡
DebbieE ok sounds good. Let me try to put together something, not sure where to start but it will be something interesting to solve, I think it is much easier in DAX. Is that an option?
I could do it in DAX but I have lots of complext logic that Im setting as flags in order to make a column at the end and it seems cleaner to do it all in M so you can follow the logic