My current week code looks like this WEEK(DATE(DATE#(FiscalDate1, 'YYYYMMDD'), 'MM/DD/YYYY'))) & '-W' AS FiscalWeek, generates the week number based off the individual date. I'm looking for it to autogenerate all 52 weeks of the year for previous years.
create your own calendar and use for vMinDatum as example 01.01.2009:
MinMaxDatum: Load Min(Bestelldatum) as MinDatum, Max(Bestelldatum) as MaxDatum Resident Bestellungen;
Let vMinDatum = Peek('MinDatum', 0, 'MinMaxDatum'); Let vMaxDatum = Peek('MaxDatum', 0, 'MinMaxDatum'); Let vAnzahl = $(vMaxDatum) - $(vMinDatum) +1;
Kalender: Load *, Datum as Bestelldatum, Year(Datum) as Jahr, QuarterName(Datum) as Quartal, Month(Datum) as Monat, Day(Datum) as Tag, Weekday(Datum) as Wochentag; Load Date($(vMinDatum) + RecNo() -1) as Datum Autogenerate $(vAnzahl);
