Getting ready

To prepare for this recipe, perform the following steps:

1. Create a table using the following formula:

R01_Calendar = CALENDAR(DATE(2015,1,1),DATE(2022,12,31))

2. Create a table called R01_Sales by importing the Sales.csv file from the GitHub repository: https://github.com/PacktPublishing/DAX-Cookbook/tree/master/Chapter02.
3. Create a column in the R01_Sales table using the following formula:

Year = YEAR([Date])

4. Create another column in the R01_Sales table using the following formula:

Month = FORMAT([Date],"mmmm")

5. Create a third column in the R01_Sales table using the following formula:

Month Sort = MONTH([Date])

6. Set the Sort by column for Month to Month Sort.
7. Create a bidirectional relationship between the Date column in the R01_Sales table and the Date column in the R01_Calendar table.