Power Query
published
Search
⌃K

Date.QuarterOfYear

Date.QuarterOfYear

Returns a number indicating which quarter of the year the date falls in.
function (optional dateTime as nullable any) as nullable any

Description

Returns a number from 1 to 4 indicating which quarter of the year the date dateTime falls in. dateTime can be a date, datetime, or datetimezone value.

Category

Date

Examples

Find which quarter of the year the date #date(2011, 12, 31) falls in.
Date.QuarterOfYear(#date(2011, 12, 31))
4