Forum Discussion
Operation Last Year vs Current Year using filters
try to calculate automatically (add or sustract) selecting one month in the filters in one table. Need to compare for example sales for one year vs previous year. I has been try with this formula
Sales difference =
VAR _Date2 = MAX ( Calendrier[Annee_NUM] )
VAR _Date1 = CALCULATE ( MAX ( Calendrier[Annee_NUM] ), Calendrier[Annee_NUM] < _Date2 )
VAR _HeadCountDate1 =
CALCULATE (
SUM ( FaitVente[Montant] ),
FILTER ( ALL ( Calendrier[Annee_NUM] ), Calendrier[Annee_NUM] = _Date1 )
)
VAR _HeadCountDate2 =
CALCULATE (
SUM ( FaitVente[Montant] ),
FILTER ( ALL ( Calendrier[Annee_NUM] ), Calendrier[Annee_NUM] = _Date2 )
)
RETURN
(_HeadCountDate2 - _HeadCountDate1)
but doesn't work or something like
Sales difference = CALCULATE(SUM(LY)) - SAMEPERIODLASTYEAR.
any suggestion guys???
Thanks
David
3 Replies
- Greg_Deckler
Community Champion
Can you supply sample data and example of your expected output? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi davidacosta ,
If you're looking for the same period in the previous year (whether it's year, month, etc), use SAMEPERIODLASTYEAR, like this:
Sales Difference =[Sales Amount Total]-CALCULATE([Sales Amount Total], SAMEPERIODLASTYEAR('Date'[Date]))The output looks like this:- Hi guys,I'm making this calculation buy seems not working. "Argument 9 in SWITCH function is required"Basically what I'm doing is that, based on the selection of a specific year, the formula selects a specific sumxSWITCH(TRUE(),[Selected Date] = 2025, sumx(FACT_Financial_Sales,FACT_Financial_Sales[Bx Expected QTY FY25]),[Selected Date] = 2026, sumx(FACT_Financial_Sales,FACT_Financial_Sales[Bx Expected QTY FY26]),[Selected Date] = 2027, sumx(FACT_Financial_Sales,FACT_Financial_Sales[Bx Expected QTY FY27]),sumx(FACT_Financial_Sales,FACT_Financial_Sales[Bx Expected QTY FY28]),)much appreciated if you guide me.David
