Need Help with SAMEPERIODLASTYEAR

[JM_DAX]

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: 

1. 

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

2. 

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?¿

[v-zhangti · Accepted solution]

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.

[johnt75]

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