Announcements
cancel
Showing results for
Did you mean:
Contributor III

## Master Calendar Not Working

Hi, I know this question must have have been asked a million times but I am currently struggling for some reason with my master calendar which isn't working not sure why it isn't displaying anything for the day, month, week, year and quarter.

here is my code below, I thought I have everything required:

FIrst_Base:

Sales,

date(Date#(SalesDate,'DD/MM/YYYY')) as SalesDate,

C,

D

FROM

Sales.xlsx

(ooxml, embedded labels, table is Sheet1);

Mas_Cal:

Date(SalesDate) as SalesDate,

Year(SalesDate) as Year,

'Q' & Ceil(Month(SalesDate)/3) as Quarter,

Month(SalesDate) as Month,

Day(SalesDate) as Day,

Week(SalesDate) as Week;

Date(MinDate + Iterno() -1) as SalesDate

While(MinDate + Iterno() -1)<=Num(MaxDate);

Min(date(Date#(SalesDate,'DD/MM/YYYY'))) as MinDate,

Max(date(Date#(SalesDate,'DD/MM/YYYY'))) as MaxDate

Resident FIrst_Base;

1 Solution

Accepted Solutions
MVP

May be this:

FIrst_Base:

Sales,

Date(Date#(SalesDate,'DD/MM/YYYY')) as SalesDate,

C,

D

FROM

Sales.xlsx

(ooxml, embedded labels, table is Sheet1);

Mas_Cal:

Year(SalesDate) as Year,

'Q' & Ceil(Month(SalesDate)/3) as Quarter,

Month(SalesDate) as Month,

Day(SalesDate) as Day,

Week(SalesDate) as Week;

LOAD Date(MinDate + Iterno() -1) as SalesDate

While(MinDate + Iterno() -1)<=Num(MaxDate);

Max(SalesDate) as MaxDate

Resident FIrst_Base;

If it still doesn't work, I would suggest you to check this and make sure SalesDate actually came in as DD/MM/YYYY

Date(Date#(SalesDate,'DD/MM/YYYY')) as SalesDate,

2 Replies
MVP

May be this:

FIrst_Base:

Sales,

Date(Date#(SalesDate,'DD/MM/YYYY')) as SalesDate,

C,

D

FROM

Sales.xlsx

(ooxml, embedded labels, table is Sheet1);

Mas_Cal:

Year(SalesDate) as Year,

'Q' & Ceil(Month(SalesDate)/3) as Quarter,

Month(SalesDate) as Month,

Day(SalesDate) as Day,

Week(SalesDate) as Week;

LOAD Date(MinDate + Iterno() -1) as SalesDate

While(MinDate + Iterno() -1)<=Num(MaxDate);

Max(SalesDate) as MaxDate

Resident FIrst_Base;

If it still doesn't work, I would suggest you to check this and make sure SalesDate actually came in as DD/MM/YYYY

Date(Date#(SalesDate,'DD/MM/YYYY')) as SalesDate,

Contributor III
Author

It worked you're really good Sunny T!!!

so this was actually the problem