Forum Discussion

Gwin's avatar
Gwin
Regular Visitor
8 years ago
Solved

Seeking help implementing Dax - DriveTime

Can anyone help please?   Using this function from erik_tarnvik :   DriveTime = VAR DT =     DATEDIFF (         MAXX (             FILTER (                 ALLSELECTED ( Driving ),         ...
  • v-yulgu-msft's avatar
    8 years ago

    Hi Gwin,

     

    As the error message prompted, in DATEDIFF function, the start date cannot be greater than the end date. 

    Syntax: DATEDIFF(<start_date>, <end_date>, <interval>)

     

    So, please make a little modification to your formula:

    DriveTime 2 = 
    VAR DT =
        DATEDIFF (
            MAX ( Driving[Check In] ),
            MAXX (
                FILTER (
                    ALLSELECTED ( Driving ),
                    Driving[ID User] = MAX ( Driving[ID User] )
                        && Driving[Check Out] < MAX ( Driving[Check In] )
                ),
                Driving[Check Out]
            ),
            
            DAY
        )
    VAR DM =
        DATEDIFF (
            MAX ( Driving[Check In] ),
            MAXX (
                FILTER (
                    ALLSELECTED ( Driving ),
                    Driving[ID User] = MAX ( Driving[ID User] )
                        && Driving[Check Out] < MAX ( Driving[Check In] )
                ),
                Driving[Check Out]
            ),
            
            MINUTE
        )
    RETURN
        IF ( DT = 0, DM, BLANK () )

    Best regards,
    Yuliana Gu