Median for Days between Status Dates in same table

Hello,

I would like to calculate the Median # Days between Application Submitted (AS) Date to Success (S) Date from a table of Statuses.

Key Business Rules

• There may be multiple occurrences of a Status for an ID, use MIN date
• Exclude where there is no AS status
• Exclude where there is an AS status and no S status
• Exclude where the S date is less than the AS date

Desired answer is Median of 116.5, based on workings in Excel sheet attached.

Reading through the code below I have definitely confused myself while trying different things to get this to work.  Read at your peril.

Median =
VAR ApplicationDate =
    CALCULATE (
        MIN ( 'Status Dates'[STATUPDATE_FLD] ),
        'Status Dates'[STATUS_FLD] = "AS"
    )
VAR SuccessDate =
    CALCULATE (
        MIN ( 'Status Dates'[STATUPDATE_FLD] ),
        'Status Dates'[STATUS_FLD] = "S"
    )
VAR ExcludeBadDates =
    IF ( ApplicationDate > SuccessDate, 1, 0 )
VAR SuccessTable =
    CALCULATETABLE (
        'Status Dates',
        'Status Dates'[STATUPDATE_FLD] = ApplicationDate
            || 'Status Dates'[STATUPDATE_FLD] = SuccessDate
            && ExcludeBadDates = 0
    )
VAR AverageTimetoSuccess =
    MEDIANX (
        FILTER (
            VALUES ( 'Status Dates'[UID_FLD] ),
            CALCULATE ( COUNTROWS ( 'Status Dates' ), 'Status Dates'[STATUS_FLD] = "AS" ) > 0
                && CALCULATE ( COUNTROWS ( 'Status Dates' ), 'Status Dates'[STATUS_FLD] = "S" ) > 0
                && ExcludeBadDates = 0
        ),
        DATEDIFF ( ApplicationDate, SuccessDate, DAY )
    )
RETURN
    AverageTimetoSuccess

Data is below (cannot see how to attached PBIX and Excel file, will try to upload when at home)

Would appreciate any guidance.

Cheers

Phil