Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ptapia
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
v-kelly-msft
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!

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,

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!
 

Hi Kelly,

 

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

 

regards,

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!

 

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

 

Picture1.png

GilbertQ
Super User
Super User

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors