Date.IsInNextWeek
This function determines if a specified date and time value, dateTime, falls within the upcoming week based on the current date and time set on the system. It should be noted that when a value falls w...
This function determines if a specified date and time value, dateTime, falls within the upcoming week based on the current date and time set on the system. It should be noted that when a value falls within the present week, the function will return false. The parameter, dateTime, can be a date, datetime, or datetimezone value that needs to be assessed.
Check if the week following the current system time falls within the next week.
Use Power Query function MDate.IsInNextWeek by adding 7 days to the current date and time obtained from DateTime.FixedLocalNow().
The output will be 'true' if the week after the current system time is indeed in the next week.