Date.IsInYearToDate Function in Power Query
The Date.IsInYearToDate Function in Power Query, returns a logical value indicating whether the given Date/DateTime/DateTimeZone falls within the current year up to today’s date, also known as Year-To-Date (YTD), as determined by the current date and time on the system.
Syntax
Date.IsInYearToDate(dateTime as any) as nullable logical
- dateTime: A date, datetime, or datetimezone value to be evaluated.
Example: Let’s the current date in my system is 4 April 2025.
Power Query M
let
Source = Date.IsInYearToDate(#date(2025, 4, 12))
in
Source The output of the above code is FALSE.