Average Time between Repair Work orders

Hi SAU1111 ,

According to your descrption, I create a sample.

Here's my solution, create a measure.

Average Diff =
VAR _T =
    ADDCOLUMNS (
        'Table',
        "Diff",
            DATEDIFF (
                MAXX (
                    FILTER (
                        'Table',
                        'Table'[Repair Work Order Numbers]
                            = EARLIER ( 'Table'[Repair Work Order Numbers] ) - 1
                            && 'Table'[Porduct Name] = EARLIER ( 'Table'[Porduct Name] )
                            && 'Table'[Serial Numbers of products]
                                = EARLIER ( 'Table'[Serial Numbers of products] )
                    ),
                    'Table'[Repair Work Order Closed Date]
                ),
                'Table'[Repair Work Order Closed Date],
                DAY
            )
    )
RETURN
    AVERAGEX ( _T, [Diff] )

Get the correct result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

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

Sorry I forgot to mention that for 1 Serial numbers there can be N numbers of Work orders and there closed On date . Now problem is that more than 1 serial numbers has same repair work order closed on date . SO WOrk order numbers also be random cannot be arranged as on same day two Work order of a sequence like 1 and 2 can be for different serial numbers . Now First how to arrange by Serial Numbers all the WO and its closed on Date so that i can arrange the dates in ascending order and calculate a difference .