calculate last year sales from multiple years pass from slicer

[Mona01]

Hi,

I would like to know how we can calculate last year sale when multiple years value pass from slicer.

Example: -

Slicer have values like 2011,2012,2013,2014 if we select all the years then how we can calculate the sale.

I used the above code it is working fine when there is only 1 value select in the slicer.

lastYearsalesAmount = calculate(SUM(Yearbysale[Sales]),Yearbysale[Year] in { VALUES(Yearbysale[Year])-1}, ALLEXCEPT(Yearbysale,Yearbysale[Year]))

[v-yulgu-msft · Accepted solution]

Hi @Mona01 ,

Please refer to this measure:

lastYearsalesAmount =
CALCULATE (
    SUM ( Yearbysale[Sales] ),
    FILTER (
        ALLSELECTED ( Yearbysale ),
        Yearbysale[Year]
            = MAX ( Yearbysale[Year] ) - 1
    )
)

Best regards,

Yuliana Gu

[Mariusz]

Hi @Mona01,

Please see the below to calculate Last Years Sales

LY Sales = 
CALCULATE(
    [Sales],
    SAMEPERIODLASTYEAR('Calendar'[Date])
)

Hope this Helps
Mariusz

[Mona01]

Hi Mariusz,

I have  only a year column ,your solution is working on date . Could u suggest other option for year Column for multiple selection in slicer .

I have a table like that.

Year	Sales
2011	100
2011	100
2011	100
2012	50
2012	50
2012	50
2013	30
2013	30
2013	30
2014	20
2014	20
2014	20

In the slicer for year i select thr years (2011,2012,2013)