Forum Discussion
Contains functionality in Power Query for Power BI
Hi. I am new to DAX and was hoping there was a way to do this: I have a column with poor data quality, meaning there are a lot of variations that may be present with the word High in them. I do no...
although when you load data into power bi it will be as you want because power bi is not case sensitive
but all of these can be done in power query the way you wantpls try this
Hi Anonymous
Please use CONTAINSSTRING dax function in calculated column
Find example - https://learn.microsoft.com/en-us/dax/containsstring-function-dax
https://dax.guide/containsstring/
https://www.sqlbi.com/tv/containsstring-containsstringexact-dax-guide/
Let me know if that works for you
If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.
Thanks
Pijush
Linkedin