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.

v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
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.