Dax: Calculate difference between 2 values in same column based on date selection

[Anonymous]

Please assist with Dax syntax for measure to subtract the Med All value for the max date minus Min date for value in same column.  The user will select 2 "As of Dates" for the calculation.  Column name is Med All.

16,186 - 16,128 = 58

thanks for your assistance!

[amitchandak · Accepted solution]

@Anonymous , Try measure like

Diff =
var _max = maxx(allselected('As on date'), 'As on date'[Date])
var _min = minx(allselected('As on date'), 'As on date'[Date])
return
calculate(sum(pptcount[med all]) , filter('As on date', 'As on date'[Date] =_max)) -calculate(sum(pptcount[med all]) , filter('As on date', 'As on date'[Date] =_min))

[Anonymous]

thank you!  That was the syntax I needed.