Skip to content

DaxFunction.com

Free Power BI Reference Guide
  • Home
  • Dax Function Reference
    • Date and Time Functions
    • Filter Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Math and Trig Functions
    • Other Functions
    • Parent and Child Functions
    • Statistical Functions
    • Text Functions
    • Time Intelligence Functions
  • Power Query M Function Reference
    • Accessing Data Functions
    • Binary Functions
    • Combiner Functions
    • Comparer Functions
    • Date Functions
    • DateTime Functions
    • DateTimeZone Functions
    • Duration Functions
    • Error Handling Functions
    • Expression Functions
    • Function Values
    • List Functions
    • Lines Functions
    • Logical Functions
    • Number Functions
    • Record Functions
    • Replacer Functions
    • Splitter Functions
    • Table Functions
    • Text Functions
    • Time Functions
    • Type Functions
    • Uri Functions
    • Value Functions
  • Power BI Tutorials
    • Convert Row Data Into Columns with Modulo
    • Create a Power BI Date Slicer Drop-down
    • SUMIFS in Power BI using DAX CALCULATE
    • Matrix Visual with Measure Values in Rows

DaxFunction.com

Free Power BI Reference Guide
  • Home
  • Dax Function Reference
    • Date and Time Functions
    • Filter Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Math and Trig Functions
    • Other Functions
    • Parent and Child Functions
    • Statistical Functions
    • Text Functions
    • Time Intelligence Functions
  • Power Query M Function Reference
    • Accessing Data Functions
    • Binary Functions
    • Combiner Functions
    • Comparer Functions
    • Date Functions
    • DateTime Functions
    • DateTimeZone Functions
    • Duration Functions
    • Error Handling Functions
    • Expression Functions
    • Function Values
    • List Functions
    • Lines Functions
    • Logical Functions
    • Number Functions
    • Record Functions
    • Replacer Functions
    • Splitter Functions
    • Table Functions
    • Text Functions
    • Time Functions
    • Type Functions
    • Uri Functions
    • Value Functions
  • Power BI Tutorials
    • Convert Row Data Into Columns with Modulo
    • Create a Power BI Date Slicer Drop-down
    • SUMIFS in Power BI using DAX CALCULATE
    • Matrix Visual with Measure Values in Rows

YEAR

YEAR Returns the year of a date as a four digit integer in the range 1900-9999.


Syntax

YEAR(date)

Parameters

date – A date in datetime or text format, containing the year you want to find.

Return Value

An integer in the range 1900-9999.


Reference Data

https://docs.microsoft.com/en-us/dax/dax-function-reference

DAX Functions / Date and Time Functions / YEAR

previousConvert Row Data Into Columns with Modulo
nextYEARFRAC

DAX Functions

Date and Time Functions Filter Functions Financial Functions Information Functions
Logical Functions Math and Trig Functions Other Functions Parent and Child Functions
Statistical Functions Text Functions Time Intelligence Functions

Power Query M Functions

Accessing Data Functions Binary Functions Combiner Functions Comparer Functions Date functions DateTimeZone functions
Duration Functions Error handling Functions Expression Functions Function Values List Functions Lines Functions
Logical Functions Number Functions Record Functions Replacer Functions Splitter Functions Table functions
Text Functions Time functions Type functions Uri functions Value functions
© 2020 DaxFunction.com This data is provided “as-is” without warranty of any kind.
Contact | Site Map | Archive