Year

extracts the year from a date value

The Year() function in Power FX extracts the year from a date value, starting with 1900.

Syntax

Year(ThisItem.DateTimeColumn)

DateTimeColumn: The column contains the DateTime data

Example

In the table of Task track, there is a column Deadline which has a data value of September 18, 2024.

Syntax: Year(ThisItem.Deadline)

Result: 2024