Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to convert a column into case insensitive

Hi,

I need help convert an entire column in to case insensitive. I can convert that to either upper or lower. But my requirement is converting entire column in to case insensitive because i need to use this dataset for my paginated report,there i need to allow Camel casing in that particular parameter. I am using Direct query mode. Please suggest a solution either in dax or in power query

Need Help

3 Replies

  • vicky_'s avatar
    vicky_
    Super User
    3 years ago

    There's no way to make a whole column case insensitive. Depending on your use case, you can either duplicate the column and make it either all upper or lower, or you can look into using functions that are already case insensitive (e.g. CONTAINSSTRING in DAX)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    vicky_ But Containsstring will return a boolean column. I need the complete column with data, because i need to use that column for my parameter(filter). so the user can type their information in the filter and find it out(Parameter created as search box not dropdown) Can you please elaborate the solution.