CLOSINGBALANCEYEAR
The CLOSINGBALANCEYEAR function evaluates an expression for the last day of the year in the current context (or for the last day of the last year, if more than one is involved).
OPENINGBALANCEMONTH
The OPENINGBALANCEMONTH function evaluates an expression at the beginning of the month in the current context.
CLOSINGBALANCEQUARTER
The CLOSINGBALANCEQUARTER function evaluates an expression for the last day of the current context quarter (or for the last day of the last quarter, if more than one is involved).
DIVIDE
The DIVIDE function performs a division by returning Blank or an alternative result if the denominator is zero.
DATEADD
The DATEADD function returns a table containing a column of dates that match those involved in the current context, shifted forward or backward by a specified number of intervals.
SAMEPERIODLASTYEAR
The SAMEPERIODLASTYEAR function returns a table containing a column of dates that match those involved in the current context, shifted back one year.
PARALLEL PERIOD
The PARALLELPERIOD function returns a table containing a column of dates that match those involved in the current context, shifted forwards or backwards by a specified number of intervals but extended to the specified interval.
PREVIOUSDAY
The PREVIOUSDAY function returns a table containing a column with the date corresponding to the day before the current context.
PREVIOUSMONTH
The PREVIOUSMONTH function returns a table containing a column with the dates corresponding to the month prior to the current context.
PREVIOUSQUARTER
The PREVIOUSQUARTER function returns a table containing a column with the dates corresponding to the quarter prior to the current context.
