Power query - dividing the production plan by occupancy

[JakubWiniarczk]

Hi ! 

I've got some problem with my data from excel file. I need to calculate the amounts from production plan in Powerbi based on current day. Problem is that my system doesn't calculate the machine work schedule. My data looks like this:

I've got another table with workdays and hours

And my production plan should look like this:

Any ideas about how to do it ? 

Thanks! 

[ImkeF]

Hi @JakubWiniarczk 

please prepare a file with the sample tables and post  a link here.

Thanks.

[JakubWiniarczk]

Hey @ImkeF 

I'm attaching xml file. 

https://wetransfer.com/downloads/b8219ec129da79f81d37ca3ad58a322f20200310081033/079325b172f039e4cb2d... 

Regards  !

[ImkeF]

Hi @JakubWiniarczk 

Thank you, but in you sample data, the expected result is missing. Please add this as well so I can validate the results.

Thanks.