date field in filter pane

[s_santalucia]

Hi all,

i want to create a yeartodate filter .

ex. when i select this filter box, the dashord is filtered on the dates from the beginning of the yaer to max selected date, without insert set analysis in measure.

thanks!

[Somasundaram]

HI,

In master calendar, you can create a field AsOfDate.

Use this field for filtering. 

[Anil_Babu_Samineni]

Perhaps this? Make sure, You have to use Date format if any wrong in the condition.

If(DateField>=YearStart(Max(TOTAL DateField)) and DateField<=Max(TOTAL DateField), DateField)

[s_santalucia]

Hi, this way not work because not filter.

[sunny_talwar]

What you might need is this

The As Of Table

[Anil_Babu_Samineni]

@s_santalucia If this is not filter, Why title required as filter? I am happy, IF you can explain little more like What you want to build after filter happen and Where you want to get as field like Filter box or Script field etc.