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