For the complete documentation index, see llms.txt. This page is also available as Markdown.
NEXTNMONTH
Filters a range of data for 'n' months after the current date.
The NEXTNMONTH function can be used to select data from a given measure, for a specified number of months after the current month. It should be used in conjunction with the SELECT clause and with an aggregate function like SUM or AVERAGE.
Syntax
NEXTNMONTH(number_of_months)
Arguments
number_of_months – The number of months for which data has to be fetched. Required.
Return value
Period Range.
Example
NEXTNMONTH(15) //Returns data for 15 months before the current month
