Updated on

Date.IsInPreviousNYears is a Power Query M function that indicates whether the given date(time) value occurs during the previous number of years, 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


   dateTime as any,
   years as number,
) as nullable logical


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


Determine if the year before the current system time is in the previous two years.

// Output: true
Date.IsInPreviousNYears( Date.AddYears( DateTime.FixedLocalNow(), -1 ), 2 )

Other functions related to Date.IsInPreviousNYears are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: