sales of yesterday of past year

[Anonymous]

Hi, i wrote this funzione that return me sales for yesterday, for the current year. I want write now a measure that calculate sales of yesterday but for the past year. What should i write? Thank you

Yesterday_sales = 

CALCULATE(

    SUM(Vendite[Import])

    , M_Tem[Dat] = today()-1

)  

[lbendlin]

If you want to compare like for like (ie the same weekday) then you need to use 

Yesterday_last_year_sales = 

CALCULATE(

    SUM(Vendite[Import])

    , M_Tem[Dat] = today()-365

)  

because that will take you back exactly 52 weeks and a day.  

[Anonymous · Accepted solution]

i got solution by writing

Sales Yesterday Prev Year =

VAR _LAST = CALCULATE([Vendite],SAMEPERIODLASTYEAR(FILTER(VALUES(M_Tem[Dat]),M_Tem[Dat]=today()-1)))

RETURN

IF([Vendite],_LAST)

[ryan_mayu]

maybe you can try this

last year=

CALCULATE(

    SUM(Vendite[Import])

    , M_Tem[Dat] >=date(year(today())-1,1,1) && M_Tem[Dat] <=date(year(today())-1,12,31)

)  

yesterday lastyear=

CALCULATE(

    SUM(Vendite[Import])

    , M_Tem[Dat] =edate(today(),-12)-1

)