Measure with MINX and MAXX date of order stages

[Zosy]

Hi,
I would like to know how long in average it takes for an order to finalize.

I don't want to create a new table, I need it to be a measure. I tried to calculate the number of hours it takes for an order to complete, but I get the error "The value for 'Start' cannot be determined. Either the column doesn't exist, or there is no current row for this column."

Time to Complete Order = 
VAR _ord = SELECTEDVALUE(order[ID])
VAR _tbl = ADDCOLUMNS(
    SUMMARIZE(
        order, order[ID]),
        "Start",
        CALCULATE(MINX(FILTER(order, order[Status] = "New1"),order[Created On])),
        "End",
        CALCULATE(MAXX(FILTER(order, order[Status] = "Complete1"),order[Created On]))
        )
        RETURN
        DATEDIFF([Start],[End], Hour)

 What am I doing wrong? How can I calculate the average time?

[UdayPbi]

You can try like this 
example below is your data you have 


Create a measure like 

hour =

VAR X = MAX(Orders[time])

VAR Y = MIN(Orders[time])

RETURN

DATEDIFF(Y,X,HOUR)

You get the output like below

[johnt75 · Accepted solution]

[Start] and [End] are columns in the _tbl variable. In this instance I think you want to use variables rather than a table, try

Time to complete =
AVERAGEX (
    VALUES ( order[ID] ),
    VAR Start =
        CALCULATE ( MIN ( order[Created On] ), order[Status] = "New1" )
    VAR End =
        CALCULATE ( MAX ( order[Created On] ), order[Status] = "Complete1" )
    RETURN
        DATEDIFF ( Start, End, HOUR )
)