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
v-yulgu-msft
8 years agoMicrosoft Employee
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