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
Syntax
Date.IsInCurrentQuarter( dateTime as any ) as nullable logicalDescription
Indicates whether the given datetime value dateTime occurs during the current quarter, as determined by the current date and time on the system.
dateTime: Adate,datetime, ordatetimezonevalue to be evaluated.
Examples
Determine if the current system time is in the current quarter.
// Output: true
Date.IsInCurrentQuarter( DateTime.FixedLocalNow() )Related functions
Other functions related to Date.IsInCurrentQuarter are:
