Operation Last Year vs Current Year using filters

[davidacosta]

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

[davidacosta]

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 sumx

SWITCH(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

[Anonymous]

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:

[Greg_Deckler]

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