Master Calendar

[TeodoraBurlica]

Hello,

I have a table that looks like this:

WORKORDER,

START DATE,

END DATE,

WEEKDAY.

I want to create a master calendar with dates between min(START DATE) and Now() and link the table through WEEKDAY only which has the days of the week (1-7).

Thank you

[Mark_Little]

Hi, 

I may be miss understanding the use case here. The creation of the calendar would not be to bad, but linking it back to the weekday field in the fact field will mean it would link all the 1 to the first day of every week.

Would advise either linking to the Start date field or using canonical calendar and link table and recreating you week day field within the calendar table.

[TeodoraBurlica]

I need the method I proposed because I have the same workorder/StartDate and EndDate every day. For example:
Every Monday I have these dates:
Workorder: 1234
StartDate: 10.10.2023
EndDate: 11.10.2024

Every Tuesday I have this data:

Workorder: 1235
StartDate: 12.10.2023
EndDate: 11.10.2024