topic Dax: Calculate difference between 2 values in same column based on date selection in DAX Commands and Tips

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

Anonymous — Wed, 05 May 2021 14:30:28 GMT

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!

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

amitchandak — Wed, 05 May 2021 15:48:21 GMT

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))

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

Anonymous — Wed, 05 May 2021 18:07:57 GMT

thank you! That was the syntax I needed.