Forum Discussion

ask's avatar
ask
Icon for Helper III rankHelper III
9 years ago
Solved

How to trim space from Power BI

How to trim space in Power BI?   =trim([Name]) doesn't work in edit quries. Any clue?
Need Help
  • GilbertQ's avatar
    GilbertQ
    9 years ago

    Hi ask

     

    When you are in the Query editor, make sure your column type is set to Text.


    Then right click, select Transform and then Trim

     

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
9 years ago

Hi ask

 

When you are in the Query editor, make sure your column type is set to Text.


Then right click, select Transform and then Trim

 

  • oscar_bolanos's avatar
    oscar_bolanos
    Icon for Advocate I rankAdvocate I
    5 years ago

    Great answer!