Delta measure based on slicer selections in Matrix Table

[Tom216]

Hi, 

I have a problem in Power BI that I can’t seem to resolve and maybe one of you can.

I am attempting to find the difference between two columns in a matrix table.  The columns are based on a slicer (snapshot date).  I want this to be dynamic so that if the user selects two different snapshot dates in the slicer, the matrix table will show the difference between these newly selected dates. So to summarize:

Delta measure showing the difference between two selected snapshot dates.

Any ideas?

Thanks

[amitchandak]

@Tom216 , A measure like this should help

Measure =
var _max = maxx(allselected('Date'),'Date'[Date])
var _min = minx(allselected('Date'),'Date'[Date])
return
calculate(sum(table[tons]),filter(All(DATE), Date[Date] =_max)) - calculate(sum(table[tons]),filter(All(DATE), Date[Date] =_min))

Measure =
var _max = maxx(allselected('Date'),'Date'[Date])
var _min = minx(allselected('Date'),'Date'[Date])
return
calculate(sum(table[tons]),filter(Allselected(DATE), Date[Date] =_max)) - calculate(sum(table[tons]),filter(Allselected(DATE), Date[Date] =_min))

There is nothing column or row diff. You need to have diff measures

[Tom216 · Accepted solution]

@amitchandak , Thanks for your reply.

I tried your solution and I didn't quite work the way I intended.  I found another post which worked for me which can be found here:  https://community.powerbi.com/t5/Desktop/Difference-between-two-columns-or-rows/td-p/188185

Thanks again.