Forum Discussion
Gwin
8 years agoRegular Visitor
Seeking help implementing Dax - DriveTime
Can anyone help please? Using this function from erik_tarnvik : DriveTime = VAR DT = DATEDIFF ( MAXX ( FILTER ( ALLSELECTED ( Driving ), ...
- 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
MattAllington
8 years agoCommunity Champion
The error message suggests you have your check in and check out date comparisons back to front.
Gwin
8 years agoRegular Visitor
Do you mind running my DAX? the dates are labelled properly. Thanks