The NEXTNDAY function can be used to select data from a given measure, for a specified number of days after the current day. It should be used in conjunction with the SELECT clause and with an aggregate function like SUM or AVERAGE.
Syntax
NEXTNDAY(number_of_days)
Arguments
number_of_days – The number of days for which data has to be fetched. Required.
Return value
Range of data.
Example
NEXTNDAY(45) //Returns data for 45 days after the current day
