How to connect my Inline Table with Master Calendar

wholelottared — Mon, 20 Dec 2021 21:08:46 GMT

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;

topic How to connect my Inline Table with Master Calendar in App Development

How to connect my Inline Table with Master Calendar