Forum Discussion

JS0711's avatar
JS0711
Frequent Visitor
1 year ago

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...
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.

 

JS0711's avatar
JS0711
Frequent Visitor
1 year ago

Thank you for replying. Can your solution be adopted for my most recent update to do more than just a count of status?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi JS0711 

    Can you show us the renderings you want?

     

    Best Regards!

    Yolo Zhu

     

    • JS0711's avatar
      JS0711
      Frequent Visitor
      1 year ago

      Thank you,

      I have three specific dates attached to each job:

      1. Sale date
      2. Start Date
      3. 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