Calculate sum up to one day via a variable

[Just6]

Hello all,

I want to use the slicer to determine the day of my variable vDay.
The sum should be calculated up to this day. So add up all quantities that are smaller than my selected day.
Can someone give me a description / show me how to set this up?

Thank you!

[Aasir]

Your variable vDay should be defined as =Max(YourDateField)

Your Slicer's data field should be YourDateField

Now you can use the vDay in your expression.
Sum({< YourDateField = {"<=$(vDay)"} >} SalesQuantity)