Getting ready

To prepare for this recipe, do the following:

1. Open Power BI Desktop.
2. Use an Enter Data query to create a table called R03_Table with the following data:

Date	Customer
3/1/2015	1
12/1/2016	1
6/1/2017	2
8/1/2017	2
9/1/2017	2
1/1/2018	3
3/1/2018	3
1/1/2019	4
3/1/2019	5
8/1/2019	4
9/1/2019	3
9/1/2019	2
9/1/2019	5
9/1/2019	4
9/1/2019	6
9/1/2019	6

3. Create the following columns in R03_Table:

Month Name = FORMAT([Date],"mmmm")
Year = YEAR([Date])
Month = MONTH([Date])

4. Create the following table, R03_Dates:

R03_Dates = 
    SELECTCOLUMNS(
        GENERATESERIES(
            MIN('R03_Table'[Date]),
            MAX('R03_Table'[Date]),
            1
        ),
        "Date",
        [Value]
    )

5. Create the following columns in R03_Dates:

Month Name = FORMAT([Date],"mmmm")
Year = YEAR([Date])
Month = MONTH([Date])

6. Ensure that the R03_Table and R03_Dates tables are not related to one another.