To prepare for this recipe, do the following:
-
Open Power BI Desktop.
-
Use an Enter Data query to create a table called R09_Table that contains the following information:
|
Year |
Quarter |
Month |
Category |
Value |
|
2020 |
Q1 |
1 |
Accounts Receivable |
15,000 |
|
2020 |
Q1 |
1 |
Net Credit Sales |
30,000 |
|
2020 |
Q1 |
2 |
Accounts Receivable |
10,000 |
|
2020 |
Q1 |
2 |
Net Credit Sales |
30,000 |
|
2020 |
Q1 |
3 |
Accounts Receivable |
25,000 |
|
2020 |
Q1 |
3 |
Net Credit Sales |
60,000 |
|
2020 |
Q2 |
4 |
Accounts Receivable |
20,000 |
|
2020 |
Q2 |
4 |
Net Credit Sales |
40,000 |
|
2020 |
Q2 |
5 |
Accounts Receivable |
15,000 |
|
2020 |
Q2 |
5 |
Net Credit Sales |
20,000 |
|
2020 |
Q2 |
6 |
Accounts Receivable |
60,000 |
|
2020 |
Q2 |
6 |
Net Credit Sales |
100,000 |
|
2020 |
Q3 |
7 |
Accounts Receivable |
20,000 |
|
2020 |
Q3 |
7 |
Net Credit Sales |
100,000 |
|
2020 |
Q3 |
8 |
Accounts Receivable |
50,000 |
|
2020 |
Q3 |
8 |
Net Credit Sales |
100,000 |
|
2020 |
Q3 |
9 |
Accounts Receivable |
40,000 |
|
2020 |
Q3 |
9 |
Net Credit Sales |
80,000 |
|
2020 |
Q4 |
10 |
Accounts Receivable |
30,000 |
|
2020 |
Q4 |
10 |
Net Credit Sales |
60,000 |
|
2020 |
Q4 |
11 |
Accounts Receivable |
15,000 |
|
2020 |
Q4 |
11 |
Net Credit Sales |
30,000 |
|
2020 |
Q4 |
12 |
Accounts Receivable |
20,000 |
|
2020 |
Q4 |
12 |
Net Credit Sales |
30,000 |