List.DateTimeZones

This function retrieves a set of datetimezone values based on the specified count and starting point. The increment, represented by the step value, is a duration that is added to each value in the list.

Generate a series of 10 sequential values beginning from 5 minutes before the start of New Year's Day 2011, incrementing by 1 minute. Insert the following code in Power Query MList: DateTimeZones(#datetimezone(2011, 12, 31, 23, 55, 0, -8, 0), 10, #duration(0, 0, 1, 0)) The output will be: { #datetimezone(2011, 12, 31, 23, 55, 0, -8, 0), #datetimezone(2011, 12, 31, 23, 56, 0, -8, 0), #datetimezone(2011, 12, 31, 23, 57, 0, -8, 0), #datetimezone(2011, 12, 31, 23, 58, 0, -8, 0), #datetimezone(2011, 12, 31, 23, 59, 0, -8, 0), #datetimezone(2012, 1, 1, 0, 0, 0, -8, 0), #datetimezone(2012, 1, 1, 0, 1, 0, -8, 0), #datetimezone(2012, 1, 1, 0, 2, 0, -8, 0), #datetimezone(2012, 1, 1, 0, 3, 0, -8, 0), #datetimezone(2012, 1, 1, 0, 4, 0, -8, 0) }