List.Dates

Generates a list of dates that starts at the specified start date and has a specified length of count. The increments between each date in the list are determined by the duration value provided as step.

Generate a collection of 5 values starting from New Year's Eve 2011, with each subsequent value incrementing by 1 day. This can be achieved using Power Query MList function Dates, specifying the start date as December 31, 2011, and the duration as 5 days. The output will be a list of dates: December 31, 2011; January 1, 2012; January 2, 2012; January 3, 2012; and January 4, 2012.