Date.QuarterOfYear Function in Power Query
The Date.QuarterOfYear function in Power Query returns a number between 1 and 4 for the quarter of the year from a DateTime value.
Syntax
Date.QuarterOfYear(dateTime as any) as nullable number
Here, the parameter dateTime can be a date, datetime, or datetimezone value.
Returns
A number representing the quarter of the year:
• 1 = January to March
• 2 = April to June
• 3 = July to September
• 4 = October to December
Example:
Power Query M
let
Source = Table.FromRecords(
{
[Sales Date = #date(2024, 01, 05)], // Q1
[Sales Date = #date(2024, 01, 25)], // Q1
[Sales Date = #date(2024, 04, 10)], // Q2
[Sales Date = #date(2024, 04, 25)], // Q2
[Sales Date = #date(2024, 07, 20)], // Q3
[Sales Date = #date(2024, 07, 31)], // Q3
[Sales Date = #date(2024, 08, 15)], // Q3
[Sales Date = #date(2024, 09, 30)], // Q3
[Sales Date = #date(2024, 10, 01)], // Q4
[Sales Date = #date(2024, 10, 10)] // Q4
}
),
// Add Quarter column
AddQuarter = Table.AddColumn(Source, "Quarter", each Date.QuarterOfYear([Sales Date]))
in
AddQuarter The output of the above code is shown below:
