Forum Discussion

soldous's avatar
soldous
Icon for Advocate II rankAdvocate II
6 years ago

Measure based on dynamic date range from two dropdown slicers

Greetings DAX masters,   I have an issue which I don't know how to solve. I need to create a measure which will calculate sum of volume between two dates. But these dates I need to be dynamic based...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi

 My recommendation will be to have two calendar tables which do not have an active relationship to your start schema

Calendar1

Calendar2

Add a Slicer using Calendar1

Add another Slicer using Calendar2

 

Here is the calculated measure

calculated measure =

var _StartDate = max(Calendar1[Date])

var _EndDate = max(calendar2[Date])

return calculate(sum(dax expression), DATESBETWEEN(Calendar[DateKey], _StartDate , _EndDate  ))

 

Please let me know if this help

Tomas