DATEDIFF

DATEDIFF Returns the count of interval boundaries crossed between two dates.


Syntax

DATEDIFF(start_date, end_date, interval)

Parameters

start_date – A scalar datetime value.

end_date – A scalar datetime value Return value.

Interval – The interval to use when comparing dates. The value can be one of the following:

– SECOND
– MINUTE
– HOUR
– DAY
– WEEK
– MONTH
– QUARTER
– YEAR

Return Value

The count of interval boundaries crossed between two dates.


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Date and Time Functions / DATEDIFF