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
Date.EndOfQuarter( dateTime as any ) as any
Returns the end of the quarter that contains
dateTime. Time zone information is preserved.
datetimezonevalue from which the end of the quarter is calculated.
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 ) )
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
Other functions related to Date.EndOfQuarter are: