Forum Discussion
Solved
Dynamic Date Range in Power Query
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?
= List.Generate(() => MinDate, each _ <= MaxDate, each Date.AddDays(_, 1))
1 Reply
= List.Generate(() => MinDate, each _ <= MaxDate, each Date.AddDays(_, 1))