topic Need Help with SAMEPERIODLASTYEAR in DAX Commands and Tips

Need Help with SAMEPERIODLASTYEAR

JM_DAX — Wed, 27 Jul 2022 11:05:58 GMT

Hi guys,

im testing a measure with current sales and i want to compare this year sales until today vs last year sales until today-1.

Attached the next:

Current Year Total Sales= CALCULATE([# sales], Calendario[Year]=2022)

Previous Year Total Sales= CALCULATE([# sales], Calendario[Year]=2021)

3. How can i bring the Sales from 01/01/2021 until 22/07/2021 (today -1).

Any idea?¿

Re: Need Help with SAMEPERIODLASTYEAR

johnt75 — Wed, 27 Jul 2022 13:43:47 GMT

Previous YTD Sales = CALCULATE( [#sales], SAMEPERIODLASTYEAR( DATESBETWEEN( 'Calendario'[Date], DATE(YEAR(TODAY()), 1, 1), TODAY() - 1) ) )

Re: Need Help with SAMEPERIODLASTYEAR

v-zhangti — Mon, 01 Aug 2022 06:31:05 GMT

Hi, JM_DAX

I briefly simulated some data that I hope fits your situation.

Measure:

this year sales until today = CALCULATE ( [#sales], FILTER ( ALL ( Calendario ), Calendario[Year] = 2022 && [Date] <= TODAY () ) )

last year sales until today-1 = Var PreviousYearTotalSales = CALCULATE([#sales],FILTER(ALL(Calendario),[Year]=2021)) Var thisyearsalesuntiltoday = CALCULATE ( [#sales], FILTER ( ALL ( Calendario ), Calendario[Year] = 2022 && [Date] <TODAY ()-1 ) ) return PreviousYearTotalSales+thisyearsalesuntiltoday

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.