Dynamic Date Range in Power Query

[koiralasmn]

Hi,

For the calendar table in my project, I have been doing this in different queries.

= List.Min(#"Extracted Time"[Date])

= Date.AddDays(List.Max(#"Extracted Time"[Date]),1)

= {Number.From(#"MinDate")..Number.From(#"MaxDate")}

Is there a way to get the Calendar ranging from Min to Max using a single query?

[AlienSx · Accepted solution]

= List.Generate(() => MinDate, each _ <= MaxDate, each Date.AddDays(_, 1))