Table.DynamicallyPadColumn.pq

(MyTable as table, MyColumnName as text) =>

// Pads a number column with leading zeroes so that an alphabetical sort returns the same than a numerical sort.
// www.TheBIccountant.com

    let
        Source = Table.TransformColumns(
            MyTable,
            {
                {
                    MyColumnName,
                    each Text.PadStart(
                        Text.From(_),
                        Text.Length(
                            Text.From(
                                List.Max(
                                    Table.Column(
                                        Table.TransformColumns(
                                            MyTable,
                                            {{MyColumnName, Number.From}}
                                        ),
                                        MyColumnName
                                    )
                                )
                            )
                        ),
                        "0"
                    ),
                    type text
                }
            }
        )
    in
        Source