Getting ready

To prepare for this recipe, perform the following steps:

  1. Create a table using the following formula:
R09_Table = GENERATESERIES(DATE(2020,1,1),DATE(2020,12,31))
  1. Create a column in that table using the following formula:
MonthNo = [Value].[MonthNo]