Daily Running Totals based on weekly budget

Anything related to PowerPivot and DAX Formuale
joshua
Posts: 5
Joined: Tue May 14, 2019 3:53 am

Daily Running Totals based on weekly budget

Postby joshua » Tue Jul 21, 2020 2:22 am

Hey everyone!
I am struggling a bit with calculating daily targets based on a weekly target.
I have a budget table with a structure like
Area I Year-week I Budget

Now I need to divide that weekly budget by the working days per week.
For this purpose, the calendar has the column "isWorkingday" (1 I 0).

Now, how can I divide that weekly budget by the number of working days and accumulate this target for the whole week and month?


Best Regards

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 3 guests

cron