Forum Discussion
Historical status over time
Hi all I need help in power bi or power query to show the historical status of jobs that have a start and end date. The data looks like this : The end result / visual I want to show is across...
Thank you,
I have three specific dates attached to each job:
- Sale date
- Start Date
- Finish Date
At any time over history I want to be able to see the status of a job based on above dates eg
- Sold Not Started = Sale date but not Started Date
- Started Not Finished = Started Date but not Finished Date
- Finished = Finished Date entered
I will then want a stacked area chart showing the respective job statuses at any time over history as I slide across via a count
Also will want to able to have a list of the jobs and the associated contract value
Date Data
Job and Contract value is held in another table