OPENINGBALANCEQUARTER
Evaluates the expression at the first date of the quarter, in the current context.
Archive
OPENINGBALANCEMONTH
Evaluates the expression at the first date of the month in the current context.
NEXTYEAR
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.
NEXTQUARTER
Returns a table that contains a column of all dates in the next quarter, based on the first date specified in the dates column, in the current context.
NEXTMONTH
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.
NEXTDAY
Returns a table that contains a column of all dates from the next day, based on the first date specified in the dates column in the current context.
LASTNONBLANK
Returns the last value in the column, column, filtered by the current context, where the expression is not blank.
LASTDATE
Returns the last 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 expression is not blank.
FIRSTDATE
Returns the first date in the current context for the specified column of dates.