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:

Date.EndOfQuarter function in Power Query