Forum Discussion

Sam7's avatar
Sam7
Icon for Advocate II rankAdvocate 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 

slorin's avatar
slorin
Icon for Super User rankSuper 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