Forum Discussion
Calculate Budget per Week
Hello everyone, I have a dataset with the budget figures per month of a year. For each YYYYMM a budget figure is written down for the month. The budget table is linked to the date table via this YYY...
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