Date Set Analysis

[has75042]

I am trying to implement set analysis, where if user selects a date, I want to show cash amount up-to that date.

This is the Set Analysis I am using, but is not working

=sum({<CalendarLink={$(<=(CalendarLink))}>}total_cash_price)

For example,

If user select 6/1/2019, I want to show all the cash amount upto 6/1/2019.

[has75042]

=sum({<CalendarLink={'$(=only((CalendarLink)))'}>}total_cash_price)
This one is working, however I need to change is to all the amount less than selection date

[Vegar · Accepted solution]

Try this expression:

=sum({<
CalendarLink={"<=$(=only(CalendarLink))"}
>}total_cash_price)

[has75042]

Thanks. It worked.