Forum Discussion
Calculate Budget per Week
Hi Anonymous ,
What's your expected result base on your sample data? Could you please explain the logic with the special examples and screenshot? It would be helpful to find the solution. Thank you.
In addition, the following link is the one which has the similar requirement as yours.
Solved: Convert monthly budget to weekly budget - Microsoft Fabric Community
Best Regards
Hey Anonymous,
Thank you for your answer. I would expect that since the first calendar week in 2024 has only 4 working days, as the first of January is a public holiday, that the 45.45 daily budget for January is multiplied by the 4 working days, so for each day of week 1, 181.8 is entered. For week 2, as this week has 5 working days, 45.45 is multiplied by 5 and 227.25 is entered. Is this understandable?
Hi Anonymous ,
I created a sample pbix file(see the attachment), please check if that is what you want.
Best Regards
Thank you for the effort, we are getting closer. If I now include the daily hierarchy in the table, the daily budget is shown per daily line, the weekly budget should be fixed here and not just added up in the totals line. There are also special cases such as the 5th calendar week, which is made up of 3 working days in January and 2 in February. The total is calculated correctly in your illustration, but if you filter by week 5 only, you will see that the total is calculated incorrectly for the entire week.
Thanks for the help