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

    Justin Z. Jovic on 05 Jul 2020 22:37:44

    RE: Trim Transformation

    Saved my bottom. THanks.

    Giampaolo Pitzalis's profile image Profile Picture

    Dan 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

    Giampaolo Pitzalis on 05 Jul 2020 22:28:30

    RE: Trim Transformation

    I had forgotten where it was located! :-)