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?
Solved! Go to Solution.
Because your expression would return different values for different records, but a table or chart or any other "collection" view displays multiple records.
Because your expression would return different values for different records, but a table or chart or any other "collection" view displays multiple records.
Obviously! Thanks Marc ๐
User | Count |
---|---|
27 | |
26 | |
22 | |
22 | |
21 |