Forum Discussion

Sam7's avatar
Sam7
Advocate II
2 years ago
Solved

Power Query - How to number each column 1 to n

Hello, 

 

How do I number each row of data 1 to 5?  I want each row to be numbered, with no grouping etc.  I just want the sequence of numbering done. 

 

Thanks

 

Need Help
  • slorin's avatar
    slorin
    2 years ago

    Hi

    Add index column, transform column modulo 5 and add 1

    let
    Source = YourSource,
    Index = Table.AddIndexColumn(Source, "Index", 0, 1, Int64.Type),
    #"Modulo5+1" = Table.TransformColumns(Index, {{"Index", each Number.Mod(_, 5)+1, Int64.Type}})
    in
    #"Modulo5+1"

    Stéphane 

1 Reply

  • slorin's avatar
    slorin
    Super User
    2 years ago

    Hi

    Add index column, transform column modulo 5 and add 1

    let
    Source = YourSource,
    Index = Table.AddIndexColumn(Source, "Index", 0, 1, Int64.Type),
    #"Modulo5+1" = Table.TransformColumns(Index, {{"Index", each Number.Mod(_, 5)+1, Int64.Type}})
    in
    #"Modulo5+1"

    Stéphane