To prepare for this recipe, do the following:
- Open Power BI Desktop.
- Use an Enter Data query to create a table called R02_Table that contains the following information:
|
YearMonth |
Revenue |
Year |
MonthNum |
|
201901 |
100 |
2019 |
1 |
|
201902 |
200 |
2019 |
2 |
|
201903 |
300 |
2019 |
3 |
|
201904 |
400 |
2019 |
4 |
|
201905 |
500 |
2019 |
5 |
|
201906 |
600 |
2019 |
6 |
|
201907 |
700 |
2019 |
7 |
|
201908 |
800 |
2019 |
8 |
|
201909 |
900 |
2019 |
9 |
|
201910 |
1,000 |
2019 |
10 |
|
201911 |
1,100 |
2019 |
11 |
|
201912 |
1,200 |
2019 |
12 |
|
202001 |
1,300 |
2020 |
1 |
|
202002 |
1,400 |
2020 |
2 |
|
202003 |
1,500 |
2020 |
3 |