Show Last 2 years of Data

Power BI
1

Hi
i am trying to show last 2 years of data along with current year data ( Year 2017 to 2019) . If i use sameperiodlastyear dax function I get last year data. But I am not sure how to use the same function to get the last 2 years of data. If i use Parallelperiod dax function I get the sum. I need to show the data by month.
Enclosing the excel sheet data along with PBIX file.

Please advise on how to show last 2 years of data. Sometimes we need to show the next 2 years of data also

SaleData.xlsx (10.2 KB)
SalesData.pbix (131.1 KB)

Thanks

2

@Namjan
Can you try these:
Sales 2 Yrs Ago = CALCULATE( [Sale LY], SAMEPERIODLASTYEAR(DateTable[Date]))
Sales Next Year = CALCULATE( [Sales], DATEADD( DateTable[Date], 1, YEAR ))
Sales Next Two Years = CALCULATE( [Sales], DATEADD( DateTable[Date], 2, YEAR))

Nick

Enterprise%20DNA%20Expert%20-%20Small

3

Hi Nick

Thanks. It was so easy, sometimes you don’t see the easy stuff. Thanks

4

Yes see here also