Table of contents
TOC
Collapse the table of content
Expand the table of content

Date and Time Functions (DAX)

Owen Duncan|Last Updated: 4/19/2018

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 Function (DAX)

CALENDARAUTO Function (DAX)

DATE Function (DAX)

DATEDIFF Function (DAX)

DATEVALUE Function (DAX)

DAY Function (DAX)

EDATE Function (DAX)

EOMONTH Function (DAX)

HOUR Function (DAX)

MINUTE Function (DAX)

MONTH Function (DAX)

NOW Function (DAX)

SECOND Function (DAX)

TIME Function (DAX)

TIMEVALUE Function (DAX)

TODAY Function (DAX)

WEEKDAY Function (DAX)

WEEKNUM Function (DAX)

YEAR Function (DAX)

YEARFRAC Function (DAX)

Time Intelligence Functions (DAX)

DAX Function ReferenceDAX Function Reference

© 2018 Microsoft