Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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....
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.
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.
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.
Hi kelly, I want to determine quatity per working day of each month, by facility and category:
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:
User | Count |
---|---|
64 | |
27 | |
25 | |
17 | |
11 |