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