I understand this can be confusing and quite a lot of people get caught on this.

It’s all about dealing with multiple dates in your fact table, like you are here with the workflow process.

The key here is a two-step process. First, you need to get the data model correct then, use the right DAX measure. It’s not too difficult once you know the technique here.

The technique is detailed here. It’s not the exact scenario you have but the technique of dealing with multiple dates is exactly the same.

The pattern is called ‘Events In Progress’, which is essentially what you are looking for here.

You must use the inactive relationships like the below.

You may have multiple of these if you have lots of dates.

Then you need to use this pattern of formula to get all the calculations you require

Again you might have to have many of similar formulas that look like this as it looks like you have lot’s of different calculations across many different dates.

See how you go with these techniques.

Here’s some other questions that are similar to this one that I’ve answered previously.