Date.EndOfQuarter Function in Power Query
The Date.EndOfQuarter function in Power Query returns the end of the quarter of the given date.
Syntax
Date.EndOfQuarter(dateTime as any) as any
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 QuarterEnd column
QuarterEnd = Table.AddColumn(Source, "QuarterEnd", each Date.EndOfQuarter([Sales Date]))
in
QuarterEnd The output will be shown in the following image:
