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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Ahmedx PijushRoy   Hi Guys, worked around and got the solution.

Table.ReplaceValue(#"Change Value", each [Rating], each if Text.Contains([Rating],"High",Comparer.OrdinalIgnoreCase) then "High" else [Rating], Replacer.ReplaceValue, {"Rating"})    

 

In the Applied Steps, I did an insert step after and put the formula there. It used the same column, Rating, as my original values and left null/blank as null/blank and other values without the word High in them alone.  All derivations of High in the data set were handled (still need to test the Mod-High) but so far that worked.  Just wanted to share since both of your help gave me a big boost in noodling out a solution.