Time-intelligence functions

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.

In this section

CLOSINGBALANCEMONTH

CLOSINGBALANCEQUARTER

CLOSINGBALANCEYEAR

DATEADD

DATESBETWEEN

DATESINPERIOD

DATESMTD

DATESQTD

DATESYTD

ENDOFMONTH

ENDOFQUARTER

ENDOFYEAR

FIRSTDATE

FIRSTNONBLANK

LASTDATE

LASTNONBLANK

NEXTDAY

NEXTMONTH

NEXTQUARTER

NEXTYEAR

OPENINGBALANCEMONTH

OPENINGBALANCEQUARTER

OPENINGBALANCEYEAR

PARALLELPERIOD

PREVIOUSDAY

PREVIOUSMONTH

PREVIOUSQUARTER

PREVIOUSYEAR

SAMEPERIODLASTYEAR

STARTOFMONTH

STARTOFQUARTER

STARTOFYEAR

TOTALMTD

TOTALQTD

TOTALYTD