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:
