Forum Discussion
Historical status over time
Thank you for the solution. I am only a newbie and having trouble with the Merge step. The data doesn't seem to populate as I hope and perhaps my wanted outcome has changed.
Data is below
I have successfully set up the calendar to show earliest to latest dates.
My merge function doesn't populate all dates ? Do I expand the calendar?
My desired outcome is to show status types x 3 on each job at any month interval. ie
- Before StartDate = Status1
- Between SSDate and HODate = Status2 and
- After HODate = Status3
I will want to execute a count of each status and deliver a chart in power BI and also I will then want to access a list of the UDFCode (Job) so I can access some additional dat such a contracted value from another table
Thanks again for your help
Hi JS0711
I also offered a solution above, you can refer to it to see if it can help you.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for replying. Can your solution be adopted for my most recent update to do more than just a count of status?
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