Forum Discussion
Solved
Supply and Demand graph
I have a bunch of data Supply of hours avaialbe to be burned Demand coming from different companies with different hours With calculations of extra resources needed to meet the demand ...
rForster,
Please check attached PBIX file.
Regards,
Lydia
Please help to share sample data of your table and post expected result here.
Regards,
Lydia
| July | August | September | October | November | December | |
| Supply (hrs) | 460 | 460 | 460 | 460 | 460 | 460 |
| Demand (hrs) | ||||||
| company 1 | 200 | 200 | 200 | 200 | 200 | 200 |
| company 2 | 200 | 200 | 200 | 200 | 200 | 200 |
| company 3 | 10 | 20 | 0 | 0 | 0 | 0 |
| company 4 | 18 | 0 | 0 | 0 | 0 | 0 |
| company 5 | 20 | 160 | 40 | |||
| company 6 | 20 | 160 | 20 | 0 | 0 | 0 |
| Total demand | 468 | 740 | 460 | 400 | 400 | 400 |
| Hours | -8 | -280 | 0 | 60 | 60 | 60 |
| Engineers over/under | -0.05 | -1.75 | 0 | 0.375 | 0.375 | 0.375 |
Need someone of showing this information in a graph format is there any way ?