Forum Discussion

JakubWiniarczk's avatar
JakubWiniarczk
Frequent Visitor
6 years ago

Power query - dividing the production plan by occupancy

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! 

3 Replies