Date.IsInCurrentWeek Function in Power Query

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

Syntax

The function has the following parameter:

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

Returns:

• TRUE if dateTime falls within the current full week.
• FALSE otherwise.

Example: Let’s assume the current date is 3 April 2025.

Power Query M

let
    Source = Date.IsInCurrentWeek(#date(2025, 4, 1))
in
    Source        

The output of the above code is true.

Note: • A week starts on Sunday and ends on Saturday (Power Query follows this convention).
• Useful for weekly reporting and data segmentation