I want to apply Interval Match On master Calendar

[Zuhaib_Rana]

I want to apply Interval Match on my data fields SD or EndDate. Starting date is 1995 Let's suppose i select 2005 from the year(Master Calendar ) then it should show all SD and EndDate values from 1995 to 2005.

That is my table data code

IntervalMatchs:
LOAD
EID,
DID,
DN,
SD,
EndDate
FROM [lib://Download/IntervalMatch.xlsx]
(ooxml, embedded labels, table is Sheet1);

That is my master Calendar

Min_Max:

Load

Min(SD) as MinDate,

Max(EndDate) as MaxDate

Resident IntervalMatchs;

Let vMinDate = Peek('MinDate',0,'Min_Max');

Let vMaxDate = Peek('MaxDate',0,'Min_Max');

drop Table Min_Max;

Master_Calendar:

Load *,

MonthName(SD) as MonthName,

QuarterName(SD) as QuarterName,

YearName(SD) as YearName,

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

Year(SD) as Year,

Month(SD) as Month,

WeekDay(SD) as WeekDay;

Load

Date($(vMinDate) + IterNo() - 1) as SD

AutoGenerate 1

While $(vMinDate) + IterNo() - 1 <= $(vMaxDate);

[vikasmahajan]

Hi,

Go through this video 

https://www.youtube.com/watch?v=nLKAYrsf6MM

Vikas