Forum Discussion

Flavio2021's avatar
Flavio2021
Frequent Visitor
2 years ago
Solved

Difference between date from difference table with filter

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 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.