← Back to List functions

List.Repeat

This function produces a new list that displays the number of times each item appears in the original list.

Syntax

List.Repeat(list as list, count as number) as list

About

This function produces a new list that displays the number of times each item appears in the original list.

Explanation

Generate a list consisting of {1, 2} that is repeated thrice. Utilize Power Query MList.Repeat({1, 2}, 3) to achieve the output {1, 2, 1, 2, 1, 2}.