Forum Discussion
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= 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?¿
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+thisyearsalesuntiltodayBest 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.
2 Replies
Previous YTD Sales = CALCULATE( [#sales], SAMEPERIODLASTYEAR( DATESBETWEEN( 'Calendario'[Date], DATE(YEAR(TODAY()), 1, 1), TODAY() - 1) ) )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+thisyearsalesuntiltodayBest 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.
