Getting ready

To prepare for this recipe, perform the following steps:

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

Year = YEAR([Date])

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

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