Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
s_santalucia
Partner - Creator
Partner - Creator

date field in filter pane

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!

Labels (1)
5 Replies
Somasundaram
Creator III
Creator III

HI,

 

In master calendar, you can create a field AsOfDate.

Use this field for filtering. 


-Somasundaram

If this resolves your Query please like and accept this as an answer.
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)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
s_santalucia
Partner - Creator
Partner - Creator
Author

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.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful