Power Query
Search…
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.
1
Date.QuarterOfYear(#date(2011, 12, 31))
Copied!
4
Last modified 3yr ago