Production calendar with quantities

Question

Hello,&nbsp;I'm trying to make a production calendar with start and end date for each production order and product as well as single and summed quantities.&nbsp; Here is a sample data, similar to the one I want to use:&nbsp;&nbsp;The visual effect which I'm looking for is something like this:&nbsp;&nbsp;Thanks!

fhill · Accepted Answer

&nbsp;I've seen a few different approaches to this type of problem, this is one using some M custom columns in Query Editor in PowerBI to generate a 'X Daily Value by Date'.&nbsp; Detailes below by each screen shot:&nbsp;Thank You,FOrrest&nbsp;1:&nbsp; Here's the first code for a Custom Column to divide the Total Production by the number of days between Start and Due.&nbsp; (Adding 1 to Inclusive the 2 dates.)= [Total_Prod_Qty] / (Duration.Days(Duration.From([Run_Due_Date]-[Run_Start_Date]))+1)&nbsp;2:&nbsp; Next we need to identify all the individual dates between the Start Date and Due Date.&nbsp; This M code will generate a Custom Column with these dates in LIST format.&nbsp; You can expand this list as shown below to get a ROW for each date between the Start and Due Dates.&nbsp; ** Adding your Daily Total in Stpe 1 FIRST automatilly spreads this value out during this steps. **=&nbsp;{ Number.From([Run_Start_Date])..Number.From([Run_Due_Date])}&nbsp;3:&nbsp; Format the new Column as a DATE for Power BI to convert the date numbers to a more user friednly format.&nbsp; Now we can start building visuals based on this new Date Custom Column in Power BI&nbsp;4:&nbsp; The Matrix in this screen shot is cloest to what you where looking to build.&nbsp; The Matrix set-up is shows in the screen shot.&nbsp; I haven't played with colors yet, but it's a start.&nbsp; I also created the stacked bar graph with nicely shows the upcoming drop off of production!&nbsp;&nbsp;

Forum Discussion

Related content

Calculate production time*quantity

Product Launch date calendar by product category

Calendar Slicer with Different Business Calendars

Custom calendar

How to calculate sub-product quantity