Calculating planned production per day within a work week (Mon-fri)

[Fredde86]

Starting of by stating the obvious that I'm new to Power BI and can´t quite figure out how to make this calculation.

Production monday through friday, 5 working days. Management wants to know how much of what is left to produce each day and divide it by how many working days are left in the week.  = ( Planned production per product group / working days left in the week ), i.e.

The reason why I can´t just make a measure for the planned production on the monday each week and divide it by 5 is because of the planning software makes new calculations each night depending on an algorithm with many parameters.

I do have a calendar table, where I have created StartofWeek and EndofWeek to try to make sense of how many working days are left in a week, but failed with the calculations.

Wished output below:

I have a single product group to make it simple. 

Weekday	Date	Product	Planned production this week	Working days left this week	Planned production per day
Monday	2024-02-12	A	100	5	20
Tuesday	2024-02-13	A	76	4	19
Wednesday	2024-02-14	A	66	3	22
Thursday	2024-02-15	A	42	2	21
Friday	2024-02-16	A	19	1	19

[lbendlin]

sounds like a standard weighted average pattern. Instead of each working day getting 20 items, some get less but others get more, and the entire week evens out.

You already did that work - what's left for you to accomplish?

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...