Fact: LOAD Belegnummer, Jahr, Monat, Wertart, Buchungsdatum, Betrag FROM [lib://AttachedFiles/fad26101-6639-46d2-981a-26cd43b5ab60.xlsx] (ooxml, embedded labels, table is [fad26101-6639-46d2-981a-26cd43b]);
MasterCalendar: Load TempDate AS Buchungsdatum, week(TempDate) As Week, Year(TempDate) As Year, Month(TempDate) As Month, monthname(TempDate) As MonthYear, Day(TempDate) As Day, 'Q' & ceil(month(TempDate) / 3) AS Quarter, Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear, WeekDay(TempDate) as WeekDay ;
//=== Generate a temp table of dates === LOAD date(mindate + IterNo()) AS TempDate ,maxdate // Used in InYearToDate() above, but not kept WHILE mindate + IterNo() <= maxdate;
//=== Get min/max dates from Field ===/ LOAD min(FieldValue('Buchungsdatum', recno()))-1 as mindate, max(FieldValue('Buchungsdatum', recno())) as maxdate AUTOGENERATE FieldValueCount('Buchungsdatum');
