Time intelligence functions
Performs a specific aggregation like min/max/avg/sum on a measure over a specified time range
Returns the start/end/previous or next time period
Filters measure values across a period range and returns only those values that satisfy specified conditions
Returns data for last n days
Returns data for last n months
Returns data for last n quarters
Returns data for last n years
Returns data for a month based on the year and month number
Returns the average of a measure over a specified date range.
Returns the sum of a measure over a specified date range.
Returns data for the current month(s) till date
Returns data for next n days
Returns data for next n months
Returns data for next n quarters
Returns data for next n years
Returns data for the current quarter(s) till date
Returns data for a range of quarters based on the year and quarter number
Returns the date after shifting a date either backwards or forwards by a specified time period
Evaluates the year-to-date value of the measure in the current context
Evaluates the quarter-to-date value of the measure in the current context
Evaluates the month-to-date value of the measure in the current context
Returns data for a year based on the input years passed
Returns the value of a measure for a specified date or a date shift relative to the current column.
Returns data for the current year(s) till date
Last updated
Was this helpful?