List.Alternate

 

This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

Returns a list with the items alternated from the original list based on a count, optional repeatInterval, and an optional offset.

List.Alternate(list as list, count as number,  optional repeatInterval as nullable number,  optional offset as nullable number) as list  

ArgumentDescription
listThe List to modify.
countAlternate count.
optional repeatIntervalAlternate repeat interval.
optional offsetAlternation offset.

If the repeatInterval and offset are not provided then List.Alternate is equivalent to List.Skip.

List.Alternate({1, 2, 3, 4, 5, 6, 7, 8, 9, 10}, 2, 2, 0) equals {3, 4, 7, 8}  

Show: