Power Query
published
Search
⌃K

Date.EndOfQuarter

Date.EndOfQuarter

Returns the last value of the quarter.
function (optional dateTime as nullable any) as nullable any

Description

Returns a date, datetime, or datetimezone value representing the end of the quarter in dateTime. Time zone information is preserved.

Category

Date

Examples

Find the end of the quarter for October 10th, 2011, 8:00AM (#datetime(2011, 10, 10, 8, 0, 0)).
Date.EndOfQuarter(#datetime(2011, 10, 10, 8, 0, 0))

datetime(2011, 12, 31, 23, 59, 59.9999999)