Calculate Sum within two dates selected by Slicer

[gustavo468]

Dear All, I want to get a difference between two last date that are selected by slicer no matter if there are consecutive or not inclusive if there are another date in the same slicer. I just want get the difference according the two last ones selected.

In my example I have this Slicer and I need to get the data difference (Sales[Sales]) between these date or if I select another dates. Always must to give me the difference between the last two dates selected.

Is it possible ?

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your expected visualization looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Sales measure: = 
SUM(Sales[Sales])

Max date sales: = 
VAR _maxdate =
    CALCULATE ( MAX ( Dates[Date] ), ALLSELECTED ( Dates ) )
RETURN
    CALCULATE ( [Sales measure:], Dates[Date] = _maxdate )

Second Max date sales: = 
VAR _maxdate =
    CALCULATE ( MAX ( Dates[Date] ), ALLSELECTED ( Dates ) )
VAR _secondmaxdate =
    CALCULATE (
        MAX ( Dates[Date] ),
        FILTER ( ALLSELECTED ( Dates ), Dates[Date] < _maxdate )
    )
RETURN
    CALCULATE ( [Sales measure:], Dates[Date] = _secondmaxdate )

Difference: = 
[Max date sales:] - [Second Max date sales:]