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

Ahmedx's avatar
Ahmedx
Super User
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

    Thanks for pasting the image as I am locked down from downloads.  I will give it a go. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I think that might work; however, as written it makes all nulls = High.  So I changed x <> to x= that doesn't happen.  Need to test some other values in data that is not present now (like low, medium) to ensure all works properly.  Thank you so much!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Ahmed, I closed the solution prematurely.  I tested it as the column has other values and it is converting all of them to High when it shouldn't.  Any thoughts?  There are many values in the column and there is no set defined list of values hence the request for something to look and only convert the ones with High, leave null/blank and ones without High in them as is.