Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Where to add a Text.RemoveRange function in M / Power Query

I understand the syntax of Text.RemoveRange but I am not sure how to add this into M / Power Query.

Scenario: TableX has a column called "Departure", which is an ID that features a leading zero. I need to remove that leading zero. So instead of "09999", "02345", etc.,  I want "9999", "2345", etc.. 

I thought it may be preceded by something like a Table.Transformrows in M e.g.,

#"Drop Lead Zero" = Table.TransformRows(#"Changed Type", Text.RemoveRange([Departure], 0, 1))

 

But this (and many other attempts) does not work. So I guess I am struggling with where to position the function in M.

 

Your advice is appreciated! 

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

Hi @Anonymous ,

 

You don't want TransformRows, you want TransformColumns, something like this:

#"Drop Lead Zero" =
Table.TransformColumns(
    #"Changed Type",
    {
        { "Departure", each Text.RemoveRange(_, 0, 1) }
    }
)

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

1 REPLY 1
BA_Pete
Super User
Super User

Hi @Anonymous ,

 

You don't want TransformRows, you want TransformColumns, something like this:

#"Drop Lead Zero" =
Table.TransformColumns(
    #"Changed Type",
    {
        { "Departure", each Text.RemoveRange(_, 0, 1) }
    }
)

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.