To prepare for this recipe, do the following:
- Open Power BI Desktop.
- Use an Enter Data query to create a table called R06_Table that contains the following information:
|
Year |
Month |
Revenue YTD |
|
2019 |
10 |
110,000,000 |
|
2019 |
11 |
122,000,000 |
|
2019 |
12 |
130,000,000 |
|
2020 |
1 |
12,000,000 |
|
2020 |
2 |
19,000,000 |
|
2020 |
3 |
31,000,000 |
|
2020 |
4 |
42,000,000 |