List.DateTimes

Updated on

List.DateTimes is a Power Query M function that generates a list of datetime values with a specified size, starting point, and step increment. The function returns a list of datetime values incremented by the given duration value.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

List.DateTimes(
   start as datetime,
   count as number,
   step as duration,
) as list

Description

Returns a list of datetime values of size count, starting at start. The given increment, step, is a duration value that is added to every value.

Examples

Create a list of 10 values starting from 5 minutes before New Year’s Day ( #datetime( 2011, 12, 31, 23, 55, 0 ) ) incrementing by 1 minute ( #duration( 0, 0, 1, 0 ) ).

List.DateTimes( #datetime( 2011, 12, 31, 23, 55, 0 ), 10, #duration( 0, 0, 1, 0 ) )

 /* Output: 
{
    #datetime( 2011, 12, 31, 23, 55, 0 ),
    #datetime( 2011, 12, 31, 23, 56, 0 ),
    #datetime( 2011, 12, 31, 23, 57, 0 ),
    #datetime( 2011, 12, 31, 23, 58, 0 ),
    #datetime( 2011, 12, 31, 23, 59, 0 ),
    #datetime( 2012, 1, 1, 0, 0, 0 ),
    #datetime( 2012, 1, 1, 0, 1, 0 ),
    #datetime( 2012, 1, 1, 0, 2, 0 ),
    #datetime( 2012, 1, 1, 0, 3, 0 ),
    #datetime( 2012, 1, 1, 0, 4, 0 )
}
 */ 

Other functions related to List.DateTimes are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/list-datetimes