November 5, 2019
Looking for some advice on how to build a time phased line chart.
I'm using power query to import and clean data and a part of that data is a start and end date. I have a total budget over that time period and need to spread that evenly across the time from the start and end date.
Task Start Date End Date Budget
Task A 10/31/2018 5/31/2019 $5,000
Task B 1/5/2019 6/27/2019 $10,000
Task C 10/31/2018 7/4/2019 $12,000
I have tens of thousands of lines of tasks and many of them are overlapping in time. I want to be able to visually portray the spikes and valleys of the business over time as tasks overlap. I want to display it on my line chart in monthly axis intervals. The assumption is that the budget is spread evenly each month.
Any help is greatly appreciated!