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
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
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!