• You need to create another table which stores all the dates between two certain dates.

    For example all days between 1900-01-01 and 2050-12-31. You can add extra columns with year, month, quarter info.

    Add a foreign key from your schedule table to this data table.

    Do the same for time: store every minute of the day in a seperate table: 00:00 till 23:59. Add yet a surrogate key in your schedule table.

    Add those two tables as dimensions in SSAS. You will be able to browse them in Excel.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP