Time Intelligence Functions (DAX)

Data Analysis Expressions (DAX) includes time intelligence functions to support the needs of Business Intelligence analysis by enabling you to manipulate data using time periods, including days, months, quarters, and years, and then build and compare calculations over those periods. The following time intelligence functions are available in DAX.

In This Section

CLOSINGBALANCEMONTH Function (DAX)

CLOSINGBALANCEQUARTER Function (DAX)

CLOSINGBALANCEYEAR Function (DAX)

DATEADD Function (DAX)

DATESBETWEEN Function (DAX)

DATESINPERIOD Function (DAX)

DATESMTD Function (DAX)

DATESQTD Function (DAX)

DATESYTD Function (DAX)

ENDOFMONTH Function (DAX)

ENDOFQUARTER Function (DAX)

ENDOFYEAR Function (DAX)

FIRSTDATE Function (DAX)

FIRSTNONBLANK Function (DAX)

LASTDATE Function (DAX)

LASTNONBLANK Function (DAX)

NEXTDAY Function (DAX)

NEXTMONTH Function (DAX)

NEXTQUARTER Function (DAX)

NEXTYEAR Function (DAX)

OPENINGBALANCEMONTH Function (DAX)

OPENINGBALANCEQUARTER Function (DAX)

OPENINGBALANCEYEAR Function (DAX)

PARALLELPERIOD Function (DAX)

PREVIOUSDAY Function (DAX)

PREVIOUSMONTH Function (DAX)

PREVIOUSQUARTER Function (DAX)

PREVIOUSYEAR Function (DAX)

SAMEPERIODLASTYEAR Function (DAX)

STARTOFMONTH Function (DAX)

STARTOFQUARTER Function (DAX)

STARTOFYEAR Function (DAX)

TOTALMTD Function (DAX)

TOTALQTD Function (DAX)

TOTALYTD Function (DAX)

See Also

Other Resources

Function Reference (DAX)

Date and Time Functions (DAX)

Filter Functions (DAX)

Information Functions (DAX)

Logical Functions (DAX)

Math and Trigonometric Functions (DAX)

Statistical Functions (DAX)

Text Functions (DAX)