Skip to main content

    Power BI

    Completed

    Trim Transformation

    Vote (1) Share
    Giampaolo Pitzalis's profile image

    Giampaolo Pitzalis on 23 Aug 2016 18:53:51

    Add new transformation in Query Editor that performs a Text.Trim step of the selected columns automatically.

    Administrator on 24 Aug 2016 00:07:07

    Thanks for the feedback - Trim is available under the Transform or Add Column tabs, within the Text Column group, there's a dropdown called "Format".

    Comments (3)
    Giampaolo Pitzalis's profile image Profile Picture

    2c74176d 1ec9-460c-ba3a-2b07d5033495 on 05 Jul 2020 22:37:44

    RE: Trim Transformation

    Saved my bottom. THanks.

    Giampaolo Pitzalis's profile image Profile Picture

    5be15243 a3f8-4908-b449-1ab894758ffe on 05 Jul 2020 22:37:38

    RE: Trim Transformation

    Not Completed - This isn't the same as Text.Trim as it only trim's spaces....

    Giampaolo Pitzalis's profile image Profile Picture

    98151ea6 f29d-440d-9951-cbb19c589f08 on 05 Jul 2020 22:28:30

    RE: Trim Transformation

    I had forgotten where it was located! :-)