DAX_Time Intelligence Functions

Name	Syntax	Return	Output Type	Description	Status	Category
OPENINGBALANCEWEEK	`OPENINGBALANCEWEEK(<expression>, <dates>[, <filter>])`	Scalar	Scalar	Evaluates the expression at the first date of the week in the current context.	Not started	Time Intelligence
OPENINGBALANCEQUARTER	`OPENINGBALANCEQUARTER(<expression>, <dates>[, <filter>])`	Scalar	Scalar	Evaluates the expression at the first date of the quarter, in the current context.		Time Intelligence
OPENINGBALANCEMONTH	`OPENINGBALANCEMONTH(<expression>, <dates>[, <filter>])`	Scalar	Scalar	Evaluates the expression at the first date of the month in the current context.	Not started	Time Intelligence
OPENINGBALANCEYEAR	`OPENINGBALANCEYEAR(<expression>, <dates>[, <filter>][, <year_end_date>])`	Scalar	Scalar	Evaluates the expression at the first date of the year in the current context.		Time Intelligence
CLOSINGBALANCEWEEK	`CLOSINGBALANCEWEEK(<expression>, <dates>[, <filter>])`	Scalar	Scalar	Evaluates the expression at the last date of the week in the current context.		Time Intelligence
CLOSINGBALANCEQUARTER	`CLOSINGBALANCEQUARTER(<expression>, <dates>[, <filter>])`	Scalar	Scalar	Evaluates the expression at the last date of the quarter in the current context.		Time Intelligence
CLOSINGBALANCEYEAR	`CLOSINGBALANCEYEAR(<expression>, <dates>[, <filter>][, <year_end_date>])`	Scalar	Scalar	Evaluates the expression at the last date of the year in the current context.		Time Intelligence
CLOSINGBALANCEMONTH	`CLOSINGBALANCEMONTH(<expression>, <dates>[, <filter>])`	Scalar	Scalar	Evaluates the expression at the last date of the month in the current context.		Time Intelligence
DATEADD	`DATEADD(<dates>, <number_of_intervals>, <interval>)`	Table	Table	Returns a table that contains a column of dates, shifted either forward or backward in time by the specified number of intervals	Done	Time Intelligence
DATESBETWEEN	`DATESBETWEEN(<dates>, <start_date>, <end_date>)`	Table	Table	Returns a table that contains a column of dates that begins with the start_date and continues until the end_date		Time Intelligence
DATESINPERIOD	`DATESINPERIOD(<dates>, <start_date>, <number_of_intervals>, <interval>)`	Table	Table	Returns a table that contains a column of dates that begins with the start_date and continues for the specified number_of_intervals		Time Intelligence
PARALLELPERIOD	`PARALLELPERIOD(<dates>, <number_of_intervals>, <interval>)`	Table	Table	Returns a table that contains a column of dates that represents a period parallel to the dates in the specified dates column		Time Intelligence
SAMEPERIODLASTYEAR	`SAMEPERIODLASTYEAR(<dates>)`	Table	Table	Returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context.		Time Intelligence
DATESWTD	`DATESWTD(<dates>[, <week_end_day>])`	Table	Table	Returns a table that contains a column of the dates for the week to date, in the current context		Time Intelligence
DATESMTD	`DATESMTD(<dates>)`	Table	Table	Returns a table that contains a column of the dates for the month to date, in the current context		Time Intelligence
DATESQTD	`DATESQTD(<dates>)`	Table	Table	Returns a table that contains a column of the dates for the quarter to date, in the current context		Time Intelligence
DATESYTD	`DATESYTD(<dates>[, <year_end_date>])`	Table	Table	Returns a table that contains a column of the dates for the year to date, in the current context		Time Intelligence
TOTALWTD	`TOTALWTD(<expression>, <dates>[, <filter>])`	Scalar	Scalar	Evaluates the value of the expression for the dates in the week to date, in the current context.	Not started	Time Intelligence
TOTALQTD	`TOTALQTD(<expression>, <dates>[, <filter>])`	Scalar	Scalar	Evaluates the value of the expression for the dates in the quarter to date, in the current context.		Time Intelligence
TOTALMTD	`TOTALMTD(<expression>, <dates>[, <filter>])`	Scalar	Scalar	Evaluates the value of the expression for the month to date, in the current context		Time Intelligence
TOTALYTD	`TOTALYTD(<expression>, <dates>[, <filter>][, <year_end_date>])`	Scalar	Scalar	Evaluates the year-to-date value of the expression in the current context.		Time Intelligence
STARTOFWEEK	`STARTOFWEEK(<dates>[, <WeekDay>])`	Date	Date	Returns the first date of the week in the current context for the specified column of dates.		Time Intelligence
STARTOFMONTH	`STARTOFMONTH(<dates>)`	Date	Date	Returns the first date of the month in the current context for the specified column of dates		Time Intelligence
STARTOFQUARTER	`STARTOFQUARTER(<dates>)`	Date	Date	Returns the first date of the quarter in the current context for the specified column of dates.		Time Intelligence
STARTOFYEAR	`STARTOFYEAR(<dates>[, <year_end_date>])`	Date	Date	Returns the first date of the year in the current context for the specified column of dates.	Not started	Time Intelligence
ENDOFWEEK	`ENDOFWEEK(<dates>[, <WeekDay>])`	Date	Date	Returns the last date of the week in the current context for the specified column of dates.	Not started	Time Intelligence
ENDOFQUARTER	`ENDOFQUARTER(<dates>)`	Date	Date	Returns the last date of the quarter in the current context for the specified column of dates.		Time Intelligence
ENDOFMONTH	`ENDOFMONTH(<dates>)`	Date	Date	Returns the last date of the month in the current context for the specified column of dates.		Time Intelligence
ENDOFYEAR	`ENDOFYEAR(<dates>[, <year_end_date>])`	Date	Date	Returns the last date of the year in the current context for the specified column of dates.		Time Intelligence
NEXTDAY	`NEXTDAY(<dates>)`	Table	Table	Returns a table that contains a column of all dates representing the day that is next to the first date in the dates column, in the current context.	Not started	Time Intelligence
NEXTWEEK	`NEXTWEEK(<dates>)`	Table	Table	Returns a table that contains a column of all dates from the next week, based on the first date in the dates column in the current context.		Time Intelligence
NEXTMONTH	`NEXTMONTH(<dates>)`	Table	Table	Returns a table that contains a column of all dates from the next month, based on the first date in the dates column in the current context.	Not started	Time Intelligence
NEXTQUARTER	`NEXTQUARTER(<dates>)`	Table	Table	Returns a table that contains a column of all dates in the next quarter, based on the first date in the dates column, in the current context.	Not started	Time Intelligence
NEXTYEAR	`NEXTYEAR(<dates>[, <year_end_date>])`	Table	Table	Returns a table that contains a column of all dates in the next year, based on the first date in the dates column, in the current context.		Time Intelligence
PREVIOUSDAY	`PREVIOUSDAY(<dates>)`	Table	Table	Returns a table that contains a column of all dates representing the day that is previous to the first date in the dates column, in the current context.		Time Intelligence
PREVIOUSWEEK	`PREVIOUSWEEK(<dates>)`	Table	Table	Returns a table that contains a column of all dates from the previous week, based on the first date in the dates column, in the current context.	Not started	Time Intelligence
PREVIOUSMONTH	`PREVIOUSMONTH(<dates>)`	Table	Table	Returns a table that contains a column of all dates from the previous month, based on the first date in the dates column, in the current context.	Not started	Time Intelligence
PREVIOUSQUARTER	`PREVIOUSQUARTER(<dates>)`	Table	Table	Returns a table that contains a column of all dates from the previous quarter, based on the first date in the dates column, in the current context.	Not started	Time Intelligence
PREVIOUSYEAR	`PREVIOUSYEAR(<dates>[, <year_end_date>])`	Table	Table	Returns a table that contains a column of all dates from the previous year, based on the first date in the dates column, in the current context.	Not started	Time Intelligence
FIRSTDATE	`FIRSTDATE(<dates>)`	Date	Date	Returns the first date in the current context for the specified column of dates.	Not started	Time Intelligence
LASTDATE	`LASTDATE(<dates>)`	Date	Date	Returns the last date in the current context for the specified column of dates.		Time Intelligence