Excel PowerPivot: DATEDIFF Function (DAX)

Excel PowerPivot DAX Function & Features

DATEDIFF Function (DAX)

Syntax:

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

Parameters:

start_date: Any DAX expression that returns a datetime value.

end_date: Any DAX expression that returns a datetime 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

Action:

Returns the count of interval boundaries crossed between two dates.