Master calendar

[#1]

Hi all

How can i create master calendar, if i have onlly this data?  i need year, yearmonth dimensions.

[ashfaq_haseeb]

Hi,

Use the below code.

Directory;

LOAD Period,

Date(Date#(Period,'MMM YYYY')) as Date,

year(Date#(Period,'MMM YYYY')) as Year,

MonthName(Date#(Period,'MMM YYYY')) as Month_Year

FROM

Calendar.xlsx

(ooxml, embedded labels, table is Sheet1);

Regards

ASHFAQ

[its_anandrjs · Accepted solution]

Create another master calendar table see the load script

Source:

LOAD

Period

FROM

Calendar.xlsx

(ooxml, embedded labels, table is Sheet1);

MasaterCalendar:

LOAD

Period,

Year(Date#(Right(Period,4),'YYYY')) as Year,

Month(Date#(Capitalize(Left(Period,3)),'MMM')) as Month,

MonthName(MakeDate(Year(Date#(Right(Period,4),'YYYY')), Month(Date#(Capitalize(Left(Period,3)),'MMM')))) AS MonthYear

Resident Source;

[#4]

Thanks!!