cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

How to determine monthly production need based on monthly working days for a year?

Please assist me in calculating the  the daily production needs per facility and product category given monthly production volume and using monthly working days. Need to build graphs and chart showing what I need to produce on a daily basis.

 

Also how can I create a dynamic calendar that will automatically calculate remaining working days in the year?

 

regards & thanks....

 
 
8 REPLIES 8
Highlighted
Super User III
Super User III

Hi there

Please provide sample data to work with

Also please provide the expected output.

This will allow people to assist you.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Highlighted
Community Support
Community Support

Hi  @ptapia ,

 

I tried to make a sample table based on your description,but I found it was a bit difficult without knowing the production of each category per facility and etc. So  you'd better provide more details such as sample data and expected output to make your requirement more clear.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Highlighted

Hi Gilbert,

Certainly… attached are sample data for Monthly production volume per facility per month, also the production volume per category. What I need is to hae the production volume per facility and category to be determined per day in any given month:

 

Picture1.png

Highlighted

Hi Kelly,

 

I appreciate inmensely your help... if I sent you my .pbix file will it be helpful?

 

Row Labels May June July August
ACC 1,800 1,380 1,910 586
CMT 1,314 7,998 5,402 8,412
PU 2,280 2,538 2,022 1,561
PVC 588 2,400 2,207 3,242
RAND 9,276 19,542 23,924 22,209
SDW 720 2,706 503 2,109
UPPER 1,422 5,567 3,703 8,221
WLT 6,978 21,038 19,674 22,831
Days Production 23 19 23 21

regards,

Highlighted

Hi @ptapia ,

 

Yes,better provide me the .pbix file.

 

Much appreciated.

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
 
Highlighted

Hi Kelly,

 

How do I do this? How can I insert a pbix file?

 

regards,

Highlighted

 

Hi kelly, I want to determine quatity per working day of each month, by facility and category:

 

Picture1.png

Highlighted

Hi  @ptapia ,

 

Sorry for the late reply.

Pls upload your .pbxi file to onedrive business and share the link with me,better attach your expected output to make the requirement clear.

Much appreciated.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors