Date and Time Functions (DAX)

Many of the date and time functions in DAX are very 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. DAX also includes a set of time intelligence functions that enable you to manipulate data using time periods, including days, months, quarters, and years, and then build and compare calculations over those periods.

In This Section

Time Intelligence Functions (DAX)

DATE Function (DAX)


DAY Function (DAX)

EDATE Function (DAX)

EOMONTH Function (DAX)

HOUR Function (DAX)

MINUTE Function (DAX)

MONTH Function (DAX)

NOW Function (DAX)

TIME Function (DAX)


SECOND Function (DAX)

TODAY Function (DAX)

WEEKDAY Function (DAX)

WEEKNUM Function (DAX)

YEAR Function (DAX)



Getting Started with Data Analysis Expressions (DAX)

DAX Syntax Specification

Date and Time Functions (DAX)

Statistical Functions (DAX)

Logical Functions (DAX)

Filter Functions (DAX)

Math and Trigonometric Functions (DAX)

See Also

Other Resources

Getting Started with Data Analysis Expressions (DAX)