Date and Time DAX Functions

YEARFRAC

Calculates the fraction of the year represented by the number of whole days between two …

MONTH

Returns the month as a number from 1 (January) to 12 (December).

YEAR

Returns the year of a date as a four digit integer in the range 1900-9999.

WEEKNUM

Returns the week number for the given date and year according to the return_type value. …

WEEKDAY

Returns a number from 1 to 7 identifying the day of the week of a …

TODAY

Returns the current date.

TIMEVALUE

Converts a time in text format to a time in datetime format.

TIME

Converts hours, minutes, and seconds given as numbers to a time in datetime format.

SECOND

Returns the seconds of a time value, as a number from 0 to 59.

QUARTER

Returns the quarter as a number from 1 (January – March) to 4 (October – …

NOW

Returns the current date and time in datetime format.

CALENDAR

Returns a table with a single column named “Date” that contains a contiguous set of …

MINUTE

Returns the minute as a number from 0 to 59, given a date and time …

HOUR

Returns the hour as a number from 0 (12:00 A.M.) to 23 (11:00 P.M.).

EOMONTH

Returns the date in datetime format of the last day of the month, before or …

EDATE

Returns the date that is the indicated number of months before or after the start …

DAY

Returns the day of the month, a number from 1 to 31.

DATEVALUE

Converts a date in text format to a date in datetime format.

DATEDIFF

Returns the count of interval boundaries crossed between two dates.

DATE

Returns the specified date in datetime format.

CALENDARAUTO

Returns a table with a single column named “Date” that contains a contiguous set of …