Forum Discussion

ak77's avatar
ak77
Icon for Post Patron rankPost Patron
2 years ago

Retain Cases in a single column

Hi all,

 

i want to retain the Case of the column where the same value in different cases retains its case when i import data from excel to powerbi. is this possible.Please help Ex: TOTAL INFRASTRUCTURE should be Upper case if exported to powerbi and Total Infrastructure should be Total Infrastructure(camel case) ans total infrastructure should be total infrastructure (lower case)

 

Please help

 

 

Need Help
Show and Tell

4 Replies

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    2 years ago

    Hi ak77 ,

     

    If I understand correctly, you want the case to be loaded into the model as is? Per testing, Power BI loads the text case as is unless you did any of the following:

    Here's the screenshot of texts loaded into the model. You can see that the cases are retained.

     

    • danextian's avatar
      danextian
      Icon for Super User rankSuper User
      2 years ago

      By the looks of it, you actually did transform the column as total infrastructure (in lowercase) is nowhere to be found in your model. They're all in Capitalize each word. If you want to retain the UPPERCASE, create a custom column with a similar formula as below and then use that column instead.

      if Text.Upper([Column]) = [Column] then [Column] else Text.Proper([Column])

       

      • ak77's avatar
        ak77
        Icon for Post Patron rankPost Patron
        2 years ago

        danextian , Thanks for reply.. Aplogies, somehow i had edited the question but missed to publish it.. i have edited the issue now.. please relook and let me know if u have solution for the same.. Thx again