Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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"
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"
Wonderful, thanks again!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |