Date.IsInPreviousNQuarters

Updated on

Date.IsInPreviousNQuarters is a Power Query M function that indicates whether the given date(time) value occurs during the previous number of quarters, 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.IsInPreviousNQuarters(
   dateTime as any,
   quarters as number,
) as nullable logical

Description

Date.IsInPreviousNQuarters determines if the dateTime argument (of type date, datetime, or datetimezone) is within a specified number of quarters before the current system date and time, excluding the current quarter. It requires a quarters argument.

Examples

Determine if the quarter before the current system time is in the previous two quarters.

// Output: true
Date.IsInPreviousNQuarters( Date.AddQuarters( DateTime.FixedLocalNow(), -1 ), 2 )

Other functions related to Date.IsInPreviousNQuarters are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/date-isinpreviousnquarters