Forum Discussion

JM_DAX's avatar
JM_DAX
New Member
4 years ago
Solved

Need Help with SAMEPERIODLASTYEAR

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= ...
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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's avatar
johnt75
Icon for Super User rankSuper User
4 years ago
Previous YTD Sales = CALCULATE( [#sales], 
SAMEPERIODLASTYEAR( DATESBETWEEN( 'Calendario'[Date], DATE(YEAR(TODAY()), 1, 1), TODAY() - 1) )
)