Date Issues

[Anonymous]

I have field (DateID) with a list of dates for example Jan-1-2018 , Jan-2-2018..... Jan-15-2018. I am using this in my set expression as

P(DateID) which shows all the dates.

There is another date AuthDate which is equal to say Jan-10-2018, then the set expression should use only the dates leading upto Jan-10-2018

How do I achieve this ?

[Anil_Babu_Samineni]

If those dates co-associates to each then expression looks

Sum({<DateID = P({<AuthDate = {"<=$(=Date(YearStart(Today()), 'MMM-DD-YYYY'))"}>} DateID)>} measure)

[Anonymous]

Why is the Date(YearStart(Today()), 'MMM-DD-YYYY' used in the expression?

[pradosh_thakur]

what about

Sum({<DateID = P({<DateID={"=(AuthDate>=DateID)"}>} DateID)>} measure)

note: it will include all dates prior to AuthDate and not only confined to current year.