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?
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.
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.
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
