Hi,
I have a simple budget table with data on the 1st of each month which I need to break down into weeks so that my actual sales data can be compared to it. Actual sales are calculated on a Sunday for the previous week, therefore I need the months breaking down to reflect the number of 'sales' weeks that will go into that month.
Table below (budget is made up so that weekly figure is 25,000) shows the base data I have. I am at a loss of what is the best way to start and I'd like to use the functionality in BI so this report can be used ongoing without me creating a new spreadsheet for the required data and bringing that in. Thanks for the help in advance.
| Month | Budget |
| 01/01/2022 | 100,000 |
| 01/02/2022 | 100,000 |
| 01/03/2022 | 125,000 |
| 01/04/2022 | 100,000 |
| 01/05/2022 | 100,000 |
| 01/06/2022 | 125,000 |
| 01/07/2022 | 100,000 |
| 01/08/2022 | 100,000 |
| 01/09/2022 | 125,000 |
| 01/10/2022 | 100,000 |
| 01/11/2022 | 125,000 |
| 01/12/2022 | 75,000 |
