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 …