Count number of times table was duplicated in Power Query

[matherhorn64]

Hi All,

I have a certain table ("Table") in Power Query and I'm using Table.Repeat function duplicate it for X number of times (X is coming from another table). What I want to do is to add to the "Table" new column which would show what duplicatation sequence it is.

For example, in "Table" I have 100 rows and I want to duplicated it for 3 times, so this new column should show me "1" for rows 1-100, "2" for rows 101-200, "3" for rows 201-300.

Any ideas how to do it?

[MarcelBeug · Accepted solution]

You can add a 0-based Index column, Integer-Divide the values by the number of rows of the original table and add 1.

let
    Source = Table1,
    Repeated = Table.Repeat(Source,Table.FirstValue(Table2)),
    #"Added Index" = Table.AddIndexColumn(Repeated, "Duplication", 0, 1),
    #"Integer-Divided Column" = Table.TransformColumns(#"Added Index", {{"Duplication", each 1 + Number.IntegerDivide(_, Table.RowCount(Source)), Int64.Type}})
in
    #"Integer-Divided Column"

[matherhorn64]

Wonderful, thanks again!