Date.IsInNextNDays

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

Description

Date.IsInNextNDays evaluates if a given value (of type date, datetime, or datetimezone) is within the next specified number of days from the system’s current date and time, excluding today’s values. It also requires specifying the number of days in the days argument.

Examples

Let’s explore two straightforward examples to understand how the Date.IsInNextNDays function works.

Checking for Dates within the Next N Days

Suppose you have a calendar table and you need a column that marks dates as true if they fall within the next n days. You can achieve this by using the Date.IsInNextNDays function on your [Date] column, with n representing the number of days you want to include.

Date.IsInNextNDays( [Date], n ) // Output depends on [Date] column and n

This expression returns true for any date in the [Date] column that falls within the next n days. For example, if you set n to 3 you can use this formula:

Date.IsInNextNDays( [Date], 3 ) // Output depends on [Date] column and n

If today is July 6, 2024, this expression will return true for all rows with dates between July 7, 2024, and July 9, 2024. Here’s a screenshot showing this:

You can see that dates within the next 3 days are marked with true.

Using the Current Date and Time

You can check if the day after the current system time falls within the next three days by using:

// Output: true
Date.IsInNextNDays( 
  Date.AddDays( DateTime.FixedLocalNow(), 1 ), 
  3 
)

Related functions

Other functions related to Date.IsInNextNDays are:

• Date.IsInNextNMonths
• Date.IsInNextNQuarters
• Date.IsInNextNWeeks
• Date.IsInNextNYears

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