Difference between date from difference table with filter

[Flavio2021]

Hi 

even if some example are present I am not yet able to do the difference of date between two table, keeping the last valide value

As you can seen in the picture I would like made the difference of date between the date of when has been created an assistance and the last valid technical action (closed date) on the second table. The table Elevation  has 4 value, but only "remote support" and "on site" must be considerate.

Thank you in advance who can show how to do, using  my example

pbix and source data available here 

here print scree about result desiderated 

[Anonymous · Accepted solution]

Hi @Flavio2021 ,

Create measure.

MEASURE =
VAR _max_date =
    CALCULATE (
        MAX ( 'Elevate'[Close on] ),
        FILTER (
            ALL ( Elevate ),
            'Elevate'[Ticked ID] = MAX ( 'Elevate'[Ticked ID] )
                && ( 'Elevate'[Activity] = "On site"
                || 'Elevate'[Activity] = "Remote Support" )
        )
    )
RETURN
    DATEDIFF ( MAX ( 'Ticket'[Created On] ), _max_date, DAY )

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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