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
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!
Solved! Go to Solution.
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
Proud to be a Datanaut!
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
Proud to be a Datanaut!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
63 | |
56 | |
27 | |
17 | |
13 |