Date.StartOfQuarter

Updated on

Date.StartOfQuarter is a Power Query M function that returns the start of the quarter that contains the specified date(Time). Your input must be a date, datetime, or datetimezone value.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Date.StartOfQuarter( dateTime as any ) as any

Description

Date.StartOfQuarter locates the beginning of the quarter for a dateTime parameter ( of type date, datetime, or datetimezone).

Examples

Find the start of the quarter for October 10th, 2011, 8:00AM.

// Output: #datetime( 2011, 10, 1, 0, 0, 0 )
Date.StartOfQuarter( #datetime( 2011, 10, 10, 8, 0, 0 ) )

Learn more about Date.StartOfQuarter in the following articles:

Other functions related to Date.StartOfQuarter are:

BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/date-startofquarter