List.DateTimeZones
A list of datetimes with a time zone 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.DateTimeZones(start as datetimezone, count as number, step as duration) as list| Parameter | Type | Description |
|---|---|---|
start | datetimezone | The first value, with its zone. |
count | number | How many values. |
step | duration | The time between them. |
Returns
list. The values; each keeps the start's zone.
Examples
Hourly readings in Central European Time
List.DateTimeZones(#datetimezone(2024, 3, 1, 9, 0, 0, 1, 0), 3, #duration(0, 1, 0, 0)){#datetimezone(2024, 3, 1, 9, 0, 0, 1, 0), #datetimezone(2024, 3, 1, 10, 0, 0, 1, 0), #datetimezone(2024, 3, 1, 11, 0, 0, 1, 0)}