Forum Discussion
Subtract between two value using date slicer
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?
- Anonymous3 years ago
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.
1 Reply
- AnonymousNot applicable
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.