ignore all fields - confusion`

[#1]

Hi

I am using this expression (in a text box for testing purposes)

=date(min({$< $(='['&Concat({1<$Field-={'Date'}>}distinct $Field,']=,[')&']=')>} Date))

This (to my knowledge) should be excluding EVERY other field in the entire model with the exception of itself.

When I select the Year 2016 I am expect to see 01/01/2016 as the result.  This works.

What I can't figure out is; Why, when I select a product category (for example) does the date jump to 04/01/2016 (i.e. the first invoice date) when the expression should be ignoring every other field...?

Any help would be appreciated.

Thanks

Oli

[sunny_talwar]

Sounds good.... keep us posted