Expression to select anything less than field

[#1]

Can I write in an expression that selects anything less than the selected date?

So for example

DATE

1st Jan 2017

1st Feb 2017

1st Mar 2017

If I select 1st Mar 2017,

My expression will show data for any dates <= 1st Mar 2017. In this case, it will show 1st Jan 2017, 1st Feb 2017 and 1st Mar 2017.

Look for something like below. But below doesn't work.

Sum({[Date2]*$<BONDMASTER_INSTRUMENT = {'CD', 'CP'}, DATE ={"$(='(<='&[Date2]')')"}>} M_TP_NOMINAL * EXC_RATE)

[Anil_Babu_Samineni]

You can do like below

Sum({<DATE = {"$('<=' & =Max(DATE))"}>}Measure)

[Chanty4u]

try like below

Sum({$<Date={"<=$(=Max(Date))"}>} Measure)

[sasikanth]

Try this

Sum({<Date={"<= $(=max(date))"}>}Sales)

make sure date formats are matching.

[sdmech81]

Hi,

I am nt sure about ur data.But it can be done like using modifier like this:  {<Date={'<=GetFieldSelections(DAte)'}>}

=SUM({<Date={'<=GetFieldSelections(DAte)'}>}Your_filed_name)

Plss try

[sdmech81]

As u want something less than selected date..

Then u use GetFieldSelections to compare as said above

Sachin

[shraddha_g]

Try

Sum({[Date2]*$<BONDMASTER_INSTRUMENT = {'CD', 'CP'}, DATE ={">=$(=date(max(DATE)))"}>} M_TP_NOMINAL * EXC_RATE)