STARTOFYEAR
Returns the first date of the year in the current context for the specified column of dates.
Archive
STARTOFQUARTER
Returns the first date of the quarter in the current context for the specified column of dates.
STARTOFMONTH
Returns the first date of the month in the current context for the specified column of dates.
SAMEPERIODLASTYEAR
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.
PREVIOUSYEAR
Returns a table that contains a column of all dates from the previous year, given the last date in the dates column, in the current context.
PREVIOUSQUARTER
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.
PREVIOUSMONTH
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.
PREVIOUSDAY
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.
PARALLELPERIOD
Returns a table that contains a column of dates that represents a period parallel to the dates in the specified dates column, in the current context, with the dates shifted a number of intervals either forward in time or back in time.
OPENINGBALANCEYEAR
Evaluates the expression at the first date of the year in the current context.