Power Query
Search…
List.Durations

List.Durations

Generates a list of duration values given an initial value, count, and incremental duration value.
function (start as duration, count as number, step as duration) as list

Description

Returns a list of count duration values, starting at start and incremented by the given duration step.

Category

List.Generators

Examples

Create a list of 5 values starting with 1 hour and incrementing by an hour.
1
List.Durations(#duration(0, 1, 0, 0), 5, #duration(0, 1, 0, 0))
Copied!
{#duration(0, 1, 0, 0),
1
#duration(0, 2, 0, 0),
2
#duration(0, 3, 0, 0),
3
#duration(0, 4, 0, 0),
4
#duration(0, 5, 0, 0)}
Copied!
Last modified 3yr ago