Date.EndOfQuarter

Date.EndOfQuarter is a Power Query M function that returns the end of the quarter, preserving time zone information. The function returns the end of the quarter as a date, datetime, or datetimezone value.

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

Syntax

Date.EndOfQuarter( dateTime as any ) as any

Description

Returns the end of the quarter that contains dateTime. Time zone information is preserved.

• dateTime: A date, datetime, or datetimezone value from which the end of the quarter is calculated.

Examples

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

// Output: #datetime( 2011, 12, 31, 23, 59, 59.9999999 )
Date.EndOfQuarter( #datetime( 2011, 10, 10, 8, 0, 0 ) )

Related articles

Learn more about Date.EndOfQuarter in the following articles:

• Create Date Table or Calendar in Power Query M
  Learn how to create a dynamic calendar table in Power Query’s M language. Build your custom columns and claim your free Date Table Script. » Read more

Related functions

Other functions related to Date.EndOfQuarter are:

• Date.EndOfDay
• Date.EndOfMonth
• Date.EndOfWeek
• Date.EndOfYear

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/date-endofquarter
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.