lock a time field for chart 's title expression

[coloful_architect]

Hi guys,

I have a table chart with a title to show the data load time where is fed by a loaded field of [data load time]

title expression is  '(Data Load Time: ' & Date(([data Load Time]),'MM/DD/YYYY') &')'

however the [data load time] does not link to all other associated data fields. so when some unassociated data field is selected, the [data load time] will be gone. 

Is that way like set expression {1} to lock this [data load time] at title expression so that it always show that [data load time]?

[vinieme12 · Accepted solution]

As below

=  '(Data Load Time: ' & Date(max({1}[data Load Time]),'MM/DD/YYYY') &')'

[coloful_architect]

yeah should have thought this workaround. thanks