Column that counts amount of rows between two dates

Hi, Anonymous 

I intercepted 40 completed data calculations in your excel.

1. Create a new date table with the receipt time and completion time.

Date =
CALENDAR ( MIN ( 'Table'[Order received] ), MAX ( 'Table'[Order completed] ) )

     2. Create a new column and calculate the orders in progress every day.

Count = 
COUNTROWS (
    FILTER (
        'Table',
        [Date] >= 'Table'[Order received]
            && [Date] < 'Table'[Order completed]
    )
)

    3. If you want to count by week, you can add a column to calculate the week of the current date.

Week = WEEKNUM([Date],1)

    4. The view is as follows.

Best Regards,

Community Support Team _Charlotte

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