Date.IsInNextWeek Function in Power Query

The Date.IsInNextWeek function in Power Query returns a logical value indicating whether the given Date/DateTime/DateTimeZone occurred during the next week, as determined by the current date and time on the system.

Syntax

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

Example: Let’s the current date in the system is 4 April 2025.

Power Query M

let
    Source = Date.IsInNextWeek(#date(2025, 4, 12))
in
    Source         

The output of the above code is TRUE.

Note: • This function will return false when passed a value that occurs within the current week.
• A week starts on Sunday and ends on Saturday by default.
• The function excludes the current week and checks if the date falls in the next full calendar week.
• Checks future dates only
• Useful for scheduling, forecasting, and weekly reports