Date Problem

[smilingjohn]

Hi Expertise please find the attachment of the QVW file ..

I have added a filter which has R_Load Date field .

If i try to sort it by descending it is not considering
and also i have tried to set the max date, by using the below expression with the text object

=Date(Max({1}[R_Load Date]),'M/D/YYYY')

=Date(Max(All [R_Load Date]),'M/D/YYYY')

But nothing is working

Need help on this

Thanks in Advance

[smilingjohn]

Hi Vipin,

My requirement is to display the max date within the filter  not in a text object , 

Therefore i am using to write an expression within the trigger ( Action) so that when i click on the text object then the max reload date should get selected with the filter of converted date .

Thanks 

[smilingjohn]

Hi Vipin, 

I want to set the max reload date within the Filter therefore i am trying to write the expression within the trigger of the text object so that when i click on it it should select the max reload date with the filter. 

Thanks 

[vipin_mishra479]

Sorry i am not get your point please correct me when you have select your max reload date in filter then why you need to pass this date on trigger .
Can you please elaborate this so that i can understand properly.

[vipin_mishra479]

Please check this is your requirement

[smilingjohn]

Actually in an dashboard i will be displaying the reload date filter , where users can select  different dates from the filter , 

and the data will be  displayed accordingly . 

I have a clear button displayed which is written within a text object when user click on the clear button the reload date to set to max value . 

i hope you are clear now 

[smilingjohn]

Hi Vipin,

at first click it will set the values default to max of relaod ,
but when i select the other dates and click on the text object it will not set max reload again ?

[vipin_mishra479]

Can you try this