Previous Year Sales

[powerbiss]

Hello,

I am trying to calculate previous year's sales with the below sample data. I used the two formulas and didnt get the right answers. I also have a date table from 2018 to 2022 with date and year column.

With the below formula, I am getting blank. 

Sales Last Year = CALCULATE(SUM(sales[Sales]), PREVIOUSYEAR(sales[Date]))

With the below formula, I am getting sales from 2018 to 2021

New_Last_Year = CALCULATE(SUM(sales[Sales]), DATEADD('Date'[Date], - 1, YEAR))

Thanks for all your help

[Anonymous]

Did you link your date table to the sales table ?

[powerbiss]

Hi James,

Yes created a relationship between Date table and Sales table. Did you get 1600

Thanks 

[v-easonf-msft · Accepted solution]

Hi， @powerbiss 

Try measuse as below:

Last Year = 
CALCULATE (
    SUM ( sales[Sales] ),
    FILTER ( 'sales', YEAR ( sales[Date] ) = YEAR ( TODAY () ) - 1 )
)

Best Regards,
Community Support Team _ Eason

[powerbiss]

Thank you v-easonf. Worked great. Really appreciate your help

[Anonymous]

the table Feuil5

Measure#1 ==> 

Sales Y = calculate(sum(Feuil5[Sales]))

Measure#2 ==> 

Sales PY = calculate([Sales Y],SAMEPERIODLASTYEAR('Date'[Date]))

and the final result

[powerbiss]

Hi James,

That worked for me. Thanks for your help

[Anonymous]

First measure 

Sales=CALCULATE(SUM(sales[Sales])

second measure ==> 

Sales PY=Calculate([Sales],SAMEPERIODELASTYEAR(Date[date])

[powerbiss]

Hi James,

I am still get 6600 instead of 1600