To prepare for this recipe, do the following:
- Open Power BI Desktop.
- Use an Enter Data query to create a table called R03_Table that contains the following information:
|
Date |
Category |
Amount |
|
1/1/2019 |
Accounts Payable |
15,000,000 |
|
12/31/2019 |
Accounts Payable |
20,000,000 |
|
1/1/2020 |
Accounts Payable |
20,000,000 |
|
12/31/2020 |
Accounts Payable |
40,000,000 |
|
12/31/2019 |
Purchases |
110,000,000 |
|
12/31/2020 |
Purchases |
100,000,000 |
This table represents a business that started in 2019 with an accounts payable balance of $15 million and ended the same year with an accounts payable balance of $20 million. During that year, the business made $110 million worth of purchases. Similarly, the business started 2020 with an accounts payable balance of $20 million and ended 2020 with an accounts payable balance of $40 million. The total purchases during 2020 came to $100 million.