Dynamic Calendar questions

Hi Anonymous,

Would you please elaborate what does Dynamic Calendar mean? 

According to the two question, I created a date table via below steps. Please review it to see whether it is acceptable.

Create a new table named as Master Calendar from your source data table.

Master Calendar=
SELECTCOLUMNS ( 'Data Table', "Year", 'Data Table'[Year], "Week", 'Data Table'[Week] )

Create a date table with continual date values. And add three calculated columns [Year Column], [Month Column] and [Week Column]. 

Dim Table =
CALENDAR ( DATE ( 2007, 1, 1 ), DATE ( 2008, 12, 31 ) )

Year Column = 'Dim Table'[Date].[Year]
Month Column = 'Dim Table'[Date].[MonthNo]
Week Column = WEEKNUM('Dim Table'[Date])

Summarize the above table 'Dim Table'.

Dim Table 2 =
SUMMARIZE (
    'Dim Table',
    'Dim Table'[Year Column],
    'Dim Table'[Week Column],
    "Month Column", LASTNONBLANK ( 'Dim Table'[Month Column], 1 )
)

Then, in Master Calendar table, create a calculated column to display Month value.

Month =
LOOKUPVALUE (
    'Dim Table 2'[Month Column],
    'Dim Table 2'[Year Column], 'Master Calendar'[Year],
    'Dim Table 2'[Week Column], 'Master Calendar'[Week]
)

If I have something misunderstood, please correct me and provide more detailed description.

Best regards,

Yuliana Gu