Min Date is not working in Chart

[mhmmd_srf]

Hi Team,

I have a requirement like below:

A intermediate table:

And in the final chart we need one date, that is Minimum of the Date, but Total Unit and Total Value will be the same.

In Final report Min date should be 6/15/2018 , but it is showing 5/22/2018.

I am attaching the file could you please check and advise.

Thanks,

Sarif

[sunny_talwar · Accepted solution]

May be you need this

=If(Column(2) <> 0 or Column(3) <> 0, Date(Min({<CstDate1 = {'>=$(=$(vMaxDate_30)) <$(=$(vMaxDate))'}, DateSnapshot_Key = {'$(=$(vDateSnapshot))'}>} CstDate1)))

[mhmmd_srf]

awesome...thank you so much...