Measure based on dynamic date range from two dropdown slicers

soldous — Wed, 13 Nov 2019 07:55:54 GMT

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 on two dropdown slicers: start date, end date.

Is it possible? Could you please help with some general syntax to solve this?

Thanks in advance

Re: Measure based on dynamic date range from two dropdown slicers

Anonymous — Wed, 13 Nov 2019 09:30:35 GMT

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

topic Re: Measure based on dynamic date range from two dropdown slicers in DAX Commands and Tips

Measure based on dynamic date range from two dropdown slicers

Re: Measure based on dynamic date range from two dropdown slicers