How to make my expression return sales for year= 2020 ?

[admin11]

Hi All

I have below expression , it return wrong value , may i know how to make it display sales for year =2020 ?

Sales_2020_ = CALCULATE([SALES_], DATESYTD(DATEADD('Date'[Date],-1,YEAR)))

Remark :- 

- I aware that i can make use of filter pan to filter for sales = 2020

My PBI sample file 

https://www.dropbox.com/s/lqeh5phegf5ybjo/PBT_V2021_400%20GL_TI_8.pbix?dl=0

Paul

[FrankAT · Accepted solution]

Hi @admin11 ,

is this what your are looking for:

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)