Forum Discussion
JakubWiniarczk
6 years agoFrequent Visitor
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
- ImkeF
Community Champion
- JakubWiniarczkFrequent Visitor
- ImkeF
Community Champion
Thank you, but in you sample data, the expected result is missing. Please add this as well so I can validate the results.
Thanks.