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
