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 | ||
| EndDate | ||
| Basis | Optional |
Return values
Scalar A single decimal value.
Remarks
If the argument is a string, it is translated into a datetime value using the same rules applied by the DATEVALUE function.
Related functions
Other related functions are:
Last update: Feb 6, 2019 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/yearfrac-function-dax