Date.EndOfYear
31 December of the year a date falls in.
Group: Dates and times. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Date.EndOfYear(dateTime as any) as any| Parameter | Type | Description |
|---|---|---|
dateTime | any | A date, datetime or datetimezone value; null gives null. |
Returns
any. The same kind of value, on 31 December.
Remarks
- For a datetime or datetimezone the answer is the last moment of that day, 23:59:59.9999999; for a date it is the date.
Examples
Year end for a sale
Date.EndOfYear(#date(2024, 5, 14))#date(2024, 12, 31)A datetimezone keeps its offset
Date.EndOfYear(#datetimezone(2024, 5, 14, 9, 0, 0, 2, 0))#datetimezone(2024, 12, 31, 23, 59, 59.9999999, 2, 0)