To prepare for this recipe, do the following:
- Open Power BI Desktop.
- Use an Enter Data query to create a table called R07_Budget that contains the following information:
|
Month |
Date |
Budget |
|
January |
1/1/2019 |
3,100,000 |
|
February |
2/1/2019 |
2,800,000 |
|
March |
3/1/2019 |
3,200,000 |
|
April |
4/1/2019 |
3,000,000 |
|
May |
5/1/2019 |
3,100,000 |
|
June |
6/1/2019 |
2,900,000 |
|
July |
7/1/2019 |
2,900,000 |
|
August |
8/1/2019 |
2,800,000 |
|
September |
9/1/2019 |
3,000,000 |
|
October |
10/1/2019 |
3,200,000 |
|
November |
11/1/2019 |
2,800,000 |
|
December |
12/1/2019 |
2,500,000 |
- Use an Enter Data query to create a table called R07_Revenue that contains the following information:
|
Date |
Revenue |
|
1/1/2019 |
100,000 |
|
1/2/2019 |
110,000 |
|
1/3/2019 |
110,000 |
|
1/4/2019 |
110,000 |
|
1/5/2019 |
115,000 |
|
1/6/2019 |
115,000 |
|
1/7/2019 |
115,000 |
|
1/8/2019 |
110,000 |
|
1/9/2019 |
110,000 |
|
1/10/2019 |
110,000 |
|
1/11/2019 |
100,000 |
|
1/12/2019 |
100,000 |
|
1/13/2019 |
100,000 |
|
1/14/2019 |
110,000 |
|
1/15/2019 |
110,000 |
|
1/16/2019 |
110,000 |
|
1/17/2019 |
115,000 |
|
1/18/2019 |
115,000 |
|
1/19/2019 |
115,000 |
|
1/20/2019 |
110,000 |
|
1/21/2019 |
110,000 |
|
1/22/2019 |
110,000 |
|
1/23/2019 |
100,000 |
|
1/24/2019 |
100,000 |
|
1/25/2019 |
100,000 |
|
1/26/2019 |
95,000 |
|
1/27/2019 |
95,000 |
|
1/28/2019 |
95,000 |
|
1/29/2019 |
90,000 |
|
1/30/2019 |
90,000 |
|
1/31/2019 |
90,000 |
|
2/1/2019 |
90,000 |
|
2/1/2019 |
90,000 |
|
2/2/2019 |
90,000 |
|
2/3/2019 |
90,000 |
|
2/4/2019 |
90,000 |
|
2/5/2019 |
95,000 |
|
2/6/2019 |
95,000 |
|
2/7/2019 |
95,000 |
|
2/8/2019 |
95,000 |
|
2/9/2019 |
95,000 |
|
2/10/2019 |
100,000 |
|
2/11/2019 |
100,000 |
|
2/12/2019 |
110,000 |
|
2/13/2019 |
110,000 |
|
2/14/2019 |
115,000 |
- Ensure that there is no relationship between these tables.