Getting Max Date in text box (and unaffected by filtering)

[zagzebski]

I have the following expression in text box:

=max(date([Date Loaded GL],'MMMM  DD YYYY'))

Works fine but want it so no matter what is filtered it continues to give me the max date. Currently if certain fields are filtered on it wipes out the date due to how my model is set up.

Thanks in advance,

Zag

[Anonymous · Accepted solution]

use set Analysis to ignore some fields or all

ignore all selections: =max({1}date([Date Loaded GL],'MMMM  DD YYYY'))

ignore some fields sselections: =max({<Field1=,Field2=>}date([Date Loaded GL],'MMMM  DD YYYY'))

  define as many fields as you want to ignore

[sunny_talwar]

Try the reverse order of date and max function and to ignore selections use {1} in the set analysis:

=Date(Max({1}[Date Loaded GL]), 'MMMM DD YYYY')

[zagzebski]

THanks!