Power Query
published
Search
⌃K

Date.StartOfQuarter

Date.StartOfQuarter

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

Description

Returns the first value of the quarter dateTime. dateTime must be a date, datetime, or datetimezone value.

Category

Date

Examples

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

datetime(2011, 10, 1, 0, 0, 0)