Display Name of column not updating to expression value

[AdamVW]

Hi

Quick question, I have a table that updates on a weekly basis. It shows the sales data of the past 6 weeks, as such:

I want to update the Display name of these columns to reflect the date of each week as text. I am using this expression:

text(any(select(RetailInfoAccess[Data_Week],and([Retailer]=[_THISROW].[Retailer],isnotblank([Data_Week])))),"dd-mm-yy")

And when I test it, it renders a value, as such

But when I look at a table or chart or any view for that matter it just defaults to the actual column name.

I have tried just placing text value "Test" as the Display Name, and that works.

Any ideas on why this will not work for an expression?

[Marc_Dillon · Accepted solution]

Because your expression would return different values for different records, but a table or chart or any other "collection" view displays multiple records.

[Adam_van_Wyk]

Obviously! Thanks Marc 😀