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