Date and time functions

These functions help you create calculations based on dates and time. Many of the functions in DAX are similar to the Excel date and time functions. However, DAX functions use a datetime data type, and can take values from a column as an argument.

In this section

CALENDAR

CALENDARAUTO

DATE

DATEDIFF

DATEVALUE

DAY

EDATE

EOMONTH

HOUR

MINUTE

MONTH

NOW

SECOND

TIME

TIMEVALUE

TODAY

WEEKDAY

WEEKNUM

YEAR

YEARFRAC