Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |