How to have expression for compute last year sales amount ?

[Anonymous]

Hi All

I need expression to compute the last year from Jan till Dec sales amount. 

For example to get current year sales amount , i use below expression :-

https://www.dropbox.com/s/wkz53debb0z7017/PBT_V01007%20how%20to%20get%20last%20year%20total%20sales....

Above link is my PBI file.

I can not using below expression , as it will only compute till YTD :-

Sales LYTD =

var _max = date(year(today())-1,month(today()),day(today()))

return

TOTALYTD(('SALES'[SALES_]),dateadd('Date'[Date],-1,year),'Date'[Date]<=_max)

[amitchandak]

@Anonymous , Please find the attached file after signature

[Anonymous]

Hi Amit

Thank you very much for your help alway

Paul

[amitchandak · Accepted solution]

@Anonymous , A measure like these should work with date table

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
This year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR('Date'[Date]),"12/31"))
Last year Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(ENDOFYEAR(dateadd('Date'[Date],-1,Year)),"12/31"))
Last to last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-2,Year),"12/31"))