Show difference between last two selected dates

[BYENER]

Hi,

I want to show the difference between the last two selected dates (adjustable with slicer). For example if my slicer starts with 19/07 and ends with 23/07 than I want to see the difference between 22/7 and 23/7.

date,count column

19/07 100

20/07 500

21/07 450

22/07 870

23/07 200

Measure have to return = 200 - 870 = - 670

I tried the followning measure, but it was not succesful

var MinDate = calculate(count(column), filter(date, min(date.date))

var MaxDate = calculate(count(column), filter(date, max(date.date))

returm = MaxDate - MinDate

Who can help me?

[amitchandak · Accepted solution]

@BYENER , Try like

measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = _max -1
return
calculate(sum(Table[Value]), filter(Table,Table[date]=_max)) -calculate(Sum(Table[Value]), filter(Table,Table[date]=_min))

measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = _max -1
return
calculate(sum(Table[Value]), filter(Date,Date[date]=_max)) -calculate(Sum(Table[Value]), filter(Date,Date[date]=_min))

refer,Power BI — Day Intelligence Questions — Time Intelligence 5–5
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...

[BYENER]

@amitchandak  thanks a lot, it's working!