trim(date([F10],'YYYYMMDD')) as [DateID], For your Fact table
Temp: Date($(vMinDate) + IterNo() - 1) as TempDate For your Temp Table
trim(date(TempDate,'YYYYMMDD')) as [DateID],
Both the date ID fields would link eachother.
Look at attached Master Calendar script. It is bit advanced where flags are also created.
Please check the Min and Max date (those might be different from what you need) also check the date format.
Master Calendar Script.docx 22.8 K
Where you have
Temp: Load Date#([DayMonthYear]) as NumericDate
Try replacing it with:
Temp: Load DayStart(Date#([DayMonthYear])) as NumericDate
I had a similar issue where I had MM/DD/YYYY, but it was as if there were hidden hours and minutes. This of course lead to my calendar not linking up to anything at all.
OH, and make sure the %calKey field on your FactTable is also DayStarted too.