Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    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 want

    pls try this

PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thank you for your response.  That creates a new column with numeric value but does not replace the words in the existing column to standardize on one word, High, that will be used in logic.  I don't know all the variations that could exist in the data so wouldn't this potentially leave some records out?