The LASTNYEAR function can be used to select data from a given measure, for a specified number of years preceding the current year. It should be used in conjunction with the SELECT clause and with an aggregate function like SUM or AVERAGE.
LASTNYEAR(number_of_quartersyears)number_of_years – The number of preceding years for which data has to be fetched. Required.
Range of data.
LASTNYEAR(2)
//Returns data for 2 years preceding the current one.png)
