Hi I'm trying to figure out how to link my inline table with master calendar. On general tutorials it shows how to implement master calendar to a linked table sourced through an excel file. But since I have an inline table, I'm having trouble to tie both the table and the master calendar table together. Any help would be greatly appreciated.
Inline Table
Table2:
LOAD *,
'Q' & ceil(month(AddMonths(Date(COB_Date2),-10))/3) AS Fiscal_Quarter
Inline [
COB_Date2, Sales
01/01/2018, 20
02/01/2018, 30
03/01/2018, 68
04/01/2019, 25
05/01/2018, 65
06/01/2020, 75
07/01/2020, 25
08/01/2018, 98]
Incorrect attempt at linking
MasterCalendarTable:
Load * Resident Table2;
Load
max(COB_Date2) as MaxDate,
min(COB_Date2) as MinDate,
Resident Table2;