Subtract between two value using date slicer

[Sviatoslav]

Using slicer as in example i want to receive (13.10.200) 200 - (1.10.2022) 100 = 100

How can i resolve it with dax functions?

[Anonymous · Accepted solution]

Hi @Sviatoslav 

Add a slicer with Between type .

Then create a measure to return the value of max date and min date to count the diff .

Measure = 
var _MAXdate=MAX('Table'[Date])
var _MINdate=MIN('Table'[Date])
return CALCULATE(SELECTEDVALUE('Table'[Value]),FILTER(ALL('Table'),'Table'[Date]=_MAXdate))-CALCULATE(SELECTEDVALUE('Table'[Value]),FILTER(ALL('Table'),'Table'[Date]=_MINdate))

The final result is like below .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.