//Power Query - zde nutné vytvořit 2 parametry typu date: startdate, enddate
#table(
  type table [
    Datum = date,
    Rok = text,
    Kvartál = text,
    RokKvartál = text,
    Měsíc = text,
    Číslo měsíce = Int32.Type,
    Day = Int32.Type,
    IsWeekend = logical
  ],
  List.Transform(
    List.Dates(startdate, Number.From(enddate) - Number.From(startdate), #duration(1, 0, 0, 0)),
    each {
      _,
      Number.ToText(Date.Year(_)),
      "Q" & Number.ToText(Date.QuarterOfYear(_)),
      Number.ToText(Date.Year(_)) & "Q" & Number.ToText(Date.QuarterOfYear(_)),
      Date.ToText(_, "MMMM", "en-CS"),
      Date.Month(_),
      Date.Day(_),
      if Date.DayOfWeek(_, Day.Monday) = 5 or Date.DayOfWeek(_, Day.Monday) = 6 then true else false
    }
  )
)