Updated on

Date.IsInPreviousDay is a Power Query M function that indicates whether the given date(time) value occurs during the previous day, as determined by the system. The function returns a boolean value (true or false).

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


Date.IsInPreviousDay( dateTime as any ) as nullable logical


Date.IsInPreviousDay determines if a datetime value occurs during the previous day, based on the current system date and time. Returns false for values within the current day. The dateTime input can be of date, datetime or datetimezone type.


Determine if the day before the current system time is in the previous day.

// Output: true
Date.IsInPreviousDay( Date.AddDays( DateTime.FixedLocalNow(), -1 ) )

Other functions related to Date.IsInPreviousDay are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: