DAX Functions - Time Intelligence

DAX Time Intelligence functions help you create calculations that support the needs of Business Intelligence analysis by enabling you to manipulate data using time periods, including days, months, quarters and years.

Following are the DAX Time Intelligence functions

• DAX 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