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 differen...
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.

     

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.