topic Re: sales of yesterday of past year in DAX Commands and Tips

sales of yesterday of past year

Anonymous — Tue, 18 Jun 2024 07:47:25 GMT

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

)

Re: sales of yesterday of past year

ryan_mayu — Tue, 18 Jun 2024 07:53:32 GMT

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

)

Re: sales of yesterday of past year

Anonymous — Tue, 18 Jun 2024 10:31:17 GMT

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)

Re: sales of yesterday of past year

lbendlin — Tue, 18 Jun 2024 13:04:13 GMT

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.