Date.IsInCurrentQuarter is a Power Query M function that indicates whether the given date(time) value occurs during the current quarter, as determined by the system. The function returns a boolean value (true or false).

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


Date.IsInCurrentQuarter( dateTime as any ) as nullable logical


Indicates whether the given datetime value dateTime occurs during the current quarter, as determined by the current date and time on the system.

  • dateTime: A date, datetime, or datetimezone value to be evaluated.


Determine if the current system time is in the current quarter.

// Output: true
Date.IsInCurrentQuarter( DateTime.FixedLocalNow() )

Other functions related to Date.IsInCurrentQuarter are:

BI Gorilla Blog

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation:
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.