List.Durations

This function retrieves a series of values based on a specified starting point, with each value increasing by a set step size.

Generate a list of 5 values, starting from 1 hour and increasing by an hour each time. Use Power Query MList.Durations function with the parameters (#duration(0, 1, 0, 0), 5, #duration(0, 1, 0, 0)). The output will be: { #duration(0, 1, 0, 0), #duration(0, 2, 0, 0), #duration(0, 3, 0, 0), #duration(0, 4, 0, 0), #duration(0, 5, 0, 0) }.