Time intelligence functions

NAME	DESCRIPTION
AGGREGATE	Performs a specific aggregation like minimum/maximum/average/sum on a measure over a specified time range.
COLUMN_PERIOD	Returns the start/end/previous or next time period
FILTER	Filters measure values across a period range and returns only those values that satisfy specified conditions
LASTNDAY	Returns data for last n days
LASTNMONTH	Returns data for last n months
LASTNQTR	Returns data for last n quarters
LASTNYEAR	Returns data for last n years
MONTHPERIOD	Returns data for a month based on the year and month number
MOVINGAVERAGE	Returns the average of a measure over a specified date range.
MOVINGSUM	Returns the sum of a measure over a specified date range.
MTD	Returns data for the current month(s) till date
NEXTNDAY	Returns data for next n days
NEXTNMONTH	Returns data for next n months
NEXTNQTR	Returns data for next n quarters
NEXTNYEAR	Returns data for next n years
QTD	Returns data for the current quarter(s) till date
QTRPERIOD	Returns data for a range of quarters based on the year and quarter number
SHIFT	Returns the date after shifting a date either backwards or forwards by a specified time period
TOTALYTD	Evaluates the year-to-date value of the measure in the current context
TOTALQTD	Evaluates the quarter-to-date value of the measure in the current context
TOTALMTD	Evaluates the month-to-date value of the measure in the current context
YEARPERIOD	Returns data for a year based on the input years passed
VALUEAT	Returns the value of a measure for a specified date or a date shift relative to the current column.
YTD	Returns data for the current year(s) till date