Table.Repeat
Returns a table containing rows from the original input table that have been duplicated a specified number of times.
Returns a table containing rows from the original input table that have been duplicated a specified number of times.
Duplicate the entries in the table by two times using Power Query MTable.Repeat function as shown below:
Table.FromRecords({
[a = 1, b = "hello"],
[a = 3, b = "world"]
}),
2
Output will be:
Table.FromRecords({
[a = 1, b = "hello"],
[a = 3, b = "world"],
[a = 1, b = "hello"],
[a = 3, b = "world"]
})