How to compute sales by year field ?

[Paulyeo11]

Hi All

Below expression will return total sales for year 2019 :- 

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

But in next 6 days i need to manually modify the above expression to get 2019 sales amount.

Can some one share with me how to modify the above expression using year=2019 , so that i dont need to maintenance.

Paul Yeo

[amitchandak · Accepted solution]

@Paulyeo11 , The above one is for last year , then 2019

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

Startic 2019 can be

Current_2019 = CALCULATE([SALES_], Filter(All('Date'), 'Date'[Year]=2019))
or
Current_2019 = CALCULATE([SALES_], Filter(All('Date'), year('Date'[Date])=2019))
or
Current_2019 = CALCULATE([SALES_], Filter('Date', 'Date'[Year]=2019))

or last to last year

Last  to Last Year= CALCULATE([SALES_], DATESYTD(DATEADD('Date'[Date],-2,YEAR)))