Forum Discussion

koiralasmn's avatar
koiralasmn
Frequent Visitor
2 years ago
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....
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago
    = List.Generate(() => MinDate, each _ <= MaxDate, each Date.AddDays(_, 1))
AlienSx's avatar
AlienSx
Super User
2 years ago
= List.Generate(() => MinDate, each _ <= MaxDate, each Date.AddDays(_, 1))