Variance between min and max of Month

[Umadhandapani]

Hi,

In the screenshot the Total is displayed as 40, but I required the Variance amount as May month amount as 30 minus Jul as 5 to be variance as 25 (i.e Month of First selected month  - Month of Last selected month (30-5) = 25, (20-30) = -10,..)

If I select all, the Variance of Apr Month minus March.

[amitchandak · Accepted solution]

@Umadhandapani , Try a measure like

Move this to total using isinscope

//Difference between two selected dates
diff =
var _max = maxx(allselected('Date'),'Date'[Date])
var _min = maxx(allselected('Date'),'Date'[Date])
return
calculate( sum(Table[Value]), filter('Date', Eomonth('Date'[Date],0) =eomonth(_min,0) )) -
calculate( sum(Table[Value]), filter('Date', Eomonth('Date'[Date],0) =eomonth(_max,0) ))

Final measure =

if(isinscope('Date'[Month]), sum(Table[Value]), [diff ])