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.
Ex:
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!
Hi Garrett,
Welcome to our forum!
You need to split your data out over the months it relates to. You can then plot the monthly data in your chart. See example file attached.
Mynda