| 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 |
