Updated on

Date.IsLeapYear is a Power Query M function that indicates whether the given date(time) value falls in a leap year. The function returns a boolean value (true or false).

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


Date.IsLeapYear( dateTime as any ) as nullable logical


Date.IsLeapYear identifies if the year of a given dateTime parameter (of type date, datetime, or datetimezone) is a leap year.


Determine if the year 2012, as represented by #date( 2012, 01, 01 ) is a leap year.

// Output: true
Date.IsLeapYear( #date( 2012, 01, 01 ) )

Other functions related to Date.IsLeapYear are:

BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot
Microsoft documentation: