YEARFRAC DAX Function (Date and Time)

Returns the year fraction representing the number of whole days between start_date and end_date.

Syntax

YEARFRAC ( <StartDate>, <EndDate> [, <Basis>] )

Parameter	Attributes	Description
StartDate		The start date in datetime format.
EndDate		The end date in datetime format.
Basis	Optional	The type of day count basis to use. 0 (default) : US (NASD) 30/360 1 : Actual/actual 2 : Actual/360 3 : Actual/365 4 : European 30/360

Scalar A single decimal value.

Fraction of the year.

If the argument is a string, it is translated into a datetime value using the same rules applied by the DATEVALUE function.

YEARFRAC can be used to compute the current age of a customer based on the difference between the current day and the customer‘s birthdate:

Age = INT ( YEARFRAC ( Customer[Birthdate], TODAY (), 1 ) )

Other related functions are:

Contributors: Alberto Ferrari, Marco Russo