Subtract between two value using date slicer

Sviatoslav — Thu, 10 Nov 2022 16:52:23 GMT

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?

Re: Subtract between two value using date slicer

Anonymous — Fri, 11 Nov 2022 02:05:02 GMT

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.

topic Subtract between two value using date slicer in DAX Commands and Tips

Subtract between two value using date slicer

Re: Subtract between two value using date slicer