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

DATEVALUE Function

DAY Function

EDATE Function

EOMONTH Function

HOUR Function

MINUTE Function

MONTH Function

NOW Function

SECOND Function

TIME Function

TIMEVALUE Function

TODAY Function

WEEKDAY Function

WEEKNUM Function

YEAR Function

YEARFRAC Function

Reference

Data Analysis Expressions (DAX) Overview

DAX Syntax Specification for PowerPivot

Related Sections

Date and Time Functions (DAX)

Statistical Functions (DAX)

Logical Functions (DAX)

Filter Functions (DAX)

Math and Trig Functions (DAX)

See Also

Concepts

Data Analysis Expressions (DAX) Overview