- DAX Functions Tutorial
- DAX Functions - Home
- DAX Functions - Introduction
- DAX Parameter Naming Conventions
- Description Structure
- DAX Functions - Aggregation
- DAX Functions - Filter
- DAX Functions - Time Intelligence
- DAX Functions - Date and Time
- DAX Functions - Information
- DAX Functions - Logical
- Math & Trigonometric Functions
- DAX Functions - Parent & Child
- DAX Functions - Statistical
- DAX Functions - Text
- DAX Functions - Other
- DAX Functions Useful Resources
- DAX Functions - Quick Guide
- DAX Functions - Useful Resources
- DAX Functions - Discussion
DAX Date & Time - YEARFRAC function
Description
Calculates the fraction of the year represented by the number of whole days between two dates.
Syntax
YEARFRAC (<start_date>, <end_date>, [<basis>])
Parameters
| Sr.No. | Parameter & Description |
|---|---|
| 1 |
start_date The start date in datetime format. |
| 2 |
end_date The end date in datetime format. |
| 3 |
basis Optional. The type of day count basis to use. An integer between 0 and 4. If not an integer, the parameter will be truncated. 0 - US (NASD) 30/360. 1 - Actual/actual. 2 - Actual/360. 3 - Actual/365. 4 - European 30/360. If omitted, default is 0. |
Return Value
A decimal number. The internal data type is a signed IEEE 64-bit (8-byte) double-precision floating-point number.
Remarks
You can use the YEARFRAC function to identify the proportion of a whole year's benefits or obligations to assign to a specific term.
DAX uses a datetime format to work with dates and times.
- If start_date or end_date are not valid dates, YEARFRAC returns an error.
- If basis < 0 or if basis > 4, YEARFRAC returns an error.
Example
= YEARFRAC ([InventoryDate], [UsageDate])
This formula returns a calculated column with fraction values representing InventoryDuration.