List.Durations
A list of durations from a start, a set count of them, each a step from the last.
Group: List. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
List.Durations(start as duration, count as number, step as duration) as list| Parameter | Type | Description |
|---|---|---|
start | duration | The first duration. |
count | number | How many durations. |
step | duration | The step between them. |
Returns
list. The durations.
Examples
Service intervals of a quarter hour
List.Durations(#duration(0, 0, 15, 0), 4, #duration(0, 0, 15, 0)){#duration(0, 0, 15, 0), #duration(0, 0, 30, 0), #duration(0, 0, 45, 0), #duration(0, 1, 0, 0)}