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

CLOSINGBALANCEQUARTER Function

CLOSINGBALANCEYEAR Function

DATEADD Function

DATESBETWEEN Function

DATESINPERIOD Function

DATESMTD Function

DATESQTD Function

DATESYTD Function

ENDOFMONTH Function

ENDOFQUARTER Function

ENDOFYEAR Function

FIRSTDATE Function

FIRSTNONBLANK Function

LASTDATE Function

LASTNONBLANK Function

NEXTDAY Function

NEXTMONTH Function

NEXTQUARTER Function

NEXTYEAR Function

OPENINGBALANCEMONTH Function

OPENINGBALANCEQUARTER Function

OPENINGBALANCEYEAR Function

PARALLELPERIOD Function

PREVIOUSDAY Function

PREVIOUSMONTH Function

PREVIOUSQUARTER Function

PREVIOUSYEAR Function

SAMEPERIODLASTYEAR Function

STARTOFMONTH Function

STARTOFQUARTER Function

STARTOFYEAR Function

TOTALMTD Function

TOTALQTD Function

TOTALYTD Function

See Also

Other Resources

DAX Function Reference

Date and Time Functions (DAX)

Filter Functions (DAX)

Information Functions (DAX)

Logical Functions (DAX)

Math and Trig Functions (DAX)

Statistical Functions (DAX)

Text Functions (DAX)