MTD

The MTD function can be used to select data from a given measure, for the current month. If an offset parameter is provided, previous months will also be returned. It should be used in conjunction with an aggregate function like SUM or AVERAGE.

Syntax

MTD(measure, offset)

Arguments

measure – The measure for which data has to be fetched. Required.

offset - Number of preceding months for which data has to be fetched. Optional.

Return value

Range of data.

Example

MTD([Sales])
//Returns data from the Sales measure for the current month
MTD([Sales,2)
//Returns data for the past 2 months and the current month

MTD with offset

MTD without offset