PowerQuery Delete last digits in Text column

[mrbajana]

I need to delete the last one or two digits by every row in the column using powerquery

[Jakinta · Accepted solution]

You can try this. Replace:

Source - your previous step

Column1 - your column name

#"Trimmed Text" = Table.TransformColumns(Source,{{"Column1", each Text.TrimEnd(_,{"0".."9"}), type text}})

OR

#"Added Custom" = Table.AddColumn(Source, "Custom", each Text.TrimEnd([Column1],{"0".."9"}))

You should Trim it one more time afterwards to remove trailing whitespaces.