Getting ready

To prepare for this recipe, perform the following steps:

1. Create a table using the following formula:

R05_Table = GENERATESERIES(DATE(2020,1,1),DATE(2020,12,31))

2. Create a column in that table using the following formula:

Month = [Value].[Month]

3. Create another column in that table using the following formula:

Weekday = FORMAT([Value], "dddd")