Working with two dates fields in table
I used this post to learn how to model something similar in PowerBI/DAX. It summarizes how to use generate to create a calculated table that has one row per date and order that shows the status.  When the users creates relationships to other tables (dates and statuses in this example) then it’s relatively straightforward to get information about number of open orders or some other information you included in the calculated table (I used contract price in my set up).