Revenues from 3 different years in only one measure

[Keks]

Hello everyone,

I would like to be able to create a single metric that would allow me to have the revenue for this year, the year N-1, and the year N-2. Is this possible?
Thanks a lot in advance.

[Fowmy · Accepted solution]

@Keks 

Use one of the following Measures:

Three Year Revenue = 
CALCULATE(
	[Sales Amount],
    DATESINPERIOD( 'Date'[Date] , DATE( YEAR( TODAY() ) , 12 , 31 ) , -3 , YEAR )
)

Three Year Revenue = 
CALCULATE(
	[Sales Amount],
    DATESINPERIOD( 'Date'[Date] , DATE( YEAR( MAX('Date'[Date] )) , 12 , 31 ) , -3 , YEAR )
)