Showing results for 
Search instead for 
Did you mean: 
Super User
Super User

CALCULATE average remaining spend time based on two tables

Hi community!

I would like to calculate the average time for each article that we should consider until the order is placed.

I have an order table that shows me for each order (2-year history) the date for each status.

Not every article has the same number of statuses.

Article Order Nr Date Status
A 1 01.01.2021 5
A 1 02.01.2021 10
B 2 02.01.2021 4



Then I have a second table that shows me if an order was completed and when:

Order Type Date
1 Ready 05.01.2021
2 Ready 04.01.2021


Now I would like to calculate the average time that was used to proceed an order from the beginning to the end.

Beside that I would also like to know the average time that is left based on the status.

In the end, I would like to get something like this as an output:

Article Status 5 Status 10 Status 15 Total Time
A 5 4 3 5
B   4 3 4


How would you build / calculate something like this?


Community Support
Community Support

Hi @joshua1990 ,

How to get the desired output?

states 5 , states 10, states 15, and the result? Sorry, due to my ignorance, can you explain this result to me?


Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User
Super User

Any ideas?

Helpful resources

Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors