Time Intelligence Functions
TOTALYTD
Evaluates the year-to-date value of the expression in the current context.
OPENINGBALANCEMONTH
Evaluates the expression at the first date of the month in the current context.
OPENINGBALANCEQUARTER
Evaluates the expression at the first date of the quarter, in the current context.
OPENINGBALANCEYEAR
Evaluates the expression at the first date of the year in the current context.
PARALLELPERIOD
Returns a table that contains a column of dates that represents a period parallel to …
PREVIOUSDAY
Returns a table that contains a column of all dates representing the day that is …
PREVIOUSMONTH
Returns a table that contains a column of all dates from the previous month, based …
PREVIOUSQUARTER
Returns a table that contains a column of all dates from the previous quarter, based …
PREVIOUSYEAR
Returns a table that contains a column of all dates from the previous year, given …
SAMEPERIODLASTYEAR
Returns a table that contains a column of dates shifted one year back in time …
STARTOFMONTH
Returns the first date of the month in the current context for the specified column …
STARTOFQUARTER
Returns the first date of the quarter in the current context for the specified column …
STARTOFYEAR
Returns the first date of the year in the current context for the specified column …
TOTALMTD
Evaluates the value of the expression for the month to date, in the current context.
TOTALQTD
Evaluates the value of the expression for the dates in the quarter to date, in …
NEXTMONTH
Returns a table that contains a column of all dates from the next month, based …
NEXTYEAR
Returns a table that contains a column of all dates in the next year, based …
NEXTQUARTER
Returns a table that contains a column of all dates in the next quarter, based …
ENDOFMONTH
Returns the last date of the month in the current context for the specified column …
CLOSINGBALANCEQUARTER
Evaluates the expression at the last date of the quarter in the current context.
CLOSINGBALANCEYEAR
Evaluates the expression at the last date of the year in the current context.
DATEADD
Returns a table that contains a column of dates, shifted either forward or backward in …
DATESBETWEEN
Returns a table that contains a column of dates that begins with the start_date and …
DATESINPERIOD
Returns a table that contains a column of dates that begins with the start_date and …
DATESMTD
Returns a table that contains a column of the dates for the month to date, …
DATESQTD
Returns a table that contains a column of the dates for the quarter to date, …
DATESYTD
Returns a table that contains a column of the dates for the year to date, …
CLOSINGBALANCEMONTH
Evaluates the expression at the last date of the month in the current context.
ENDOFQUARTER
Returns the last date of the quarter in the current context for the specified column …
ENDOFYEAR
Returns the last date of the year in the current context for the specified column …
FIRSTDATE
Returns the first date in the current context for the specified column of dates.
FIRSTNONBLANK
Returns the first value in the column, column, filtered by the current context, where the …
LASTDATE
Returns the last date in the current context for the specified column of dates.
LASTNONBLANK
Returns the last value in the column, column, filtered by the current context, where the …
NEXTDAY
Returns a table that contains a column of all dates from the next day, based …