PREVIOUSYEAR
The PREVIOUSYEAR function returns a table containing a column with the dates corresponding to the year prior to the current context.
NEXTDAY
The NEXTDAY function returns a table containing a column with the date corresponding to the day after the current context.
NEXTMONTH
The NEXTMONTH function returns a table containing a column with the dates corresponding to the month after the current context.
NEXTQUARTER
The NEXTQUARTER function returns a table containing a column with the dates corresponding to the quarter following the current context.
NEXTYEAR
The NEXTYEAR function returns a table containing a column with the dates corresponding to the year following the current context.
DATESBETWEEN
The DATESBETWEEN function returns a table containing a single column of dates that begins and ends with the dates included as parameters.
FIRSTDATE
The FIRSTDATE function returns the first day in the current context for the specified date column.
LASTDATE
The LASTDATE function returns the last day in the current context for the specified date column.
ALL
The ALL function returns all the rows in a table or all the values in one or more columns, ignoring any filters that have been applied.
CALCULATE
The CALCULATE function evaluates an expression in a context that is modified by the filters that are included as arguments.
