set analisys with dates

[ilanbaruch]

hi all,

in my model i have two dates one is used for the master calendar (Date)

and the second is a transaction reference date (ValueDate)

i want an expression that ignores Date Field, and calculates by all smaller ValueDate 's from possible Date

i.e when model's data set include year 2018, and user selected April-18, calculation should include Jan-18 to Apr-18

advanced thanks

[lironbaram · Accepted solution]

hi 

it should be something like 

sum({<Date,ValueDate={"<=$(=max(Date))"}>}Sales)

[ilanbaruch]

Thank you Liron!
my final :
sum({$<Date=, ValueDate= {"<=$(vPossibleDates)"} > } Sales)
vPossibleDates=Date(max(ValueDate))