Generate list with double characters

[laui]

Hi there,

As titled. I wish to generate a list {M04..M10} to M04, M05, M06, M07, M08, M09, M10. Is there an function similar to List.Numbers that can help?

Isaac

[v-yuta-msft · Accepted solution]

Hi laui,

To achieve your requirement, you can use M code like below:

let
    Source =  List.Numbers(4, 7, 1),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Concatenate" = Table.AddColumn(#"Converted to Table", "Concatenate Column", each if [Column1] >= 10 then "M" & Text.From([Column1]) else "M0" & Text.From([Column1])),
    #"Concatenate Column" = Concatenate[Concatenate Column]
in
    #"Concatenate Column"

Regards,

Jimmy Tao