i want to substract data in same column

[benjawan]

i want to substract data in same column when i click year month and value

example

select = year 2565,year 2562   

select month and select value

result = -56

[amitchandak · Accepted solution]

@benjawan , if you want two select two years in the same slicer and want a difference

new measure  diff (max -min) =
var _max = maxx(allselected(Date),Date[Year])
var _min = minx(allselected(Date),Date[Year])
return

calculate( sum(Table[Value]), filter('Date', 'Date'[Year] =_max)) -
calculate( sum(Table[Value]), filter('Date', 'Date'[Year] =_min))

In case you need two slicers 

How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg