Dynamic header in calculated table

[obriaincian]

Is there a way to make column headers in calculated tables dynamic?

Heres the code I have to create a calculated table

CalcTable = 

SUMMARIZECOLUMNS(Data[Company],
"No. Employees",CALCULATE(DISTINCTCOUNT(Data[Employee_Number])))

I'd like to change the column name to reflect the current date e.g. "No. Emplyees as of" & Today(), is this possible?

I have also tried to add a variable when creating the calculated table but from what I gather that only works when you use Union

[MFelix · Accepted solution]

I know but this can be adjusted to a table visualization, if you use on the columns value that new column created the header will be dynamic.

[obriaincian]

@MFelix Thank you for the suggestion but I'm looking to see if column headers can be dynamic rather than legends in a visual

[MFelix]

Hi @obriaincian ,

You cannot change the name of the columns on dinamically on calculated tables, this would break your visualizations because the name would be changing each day. What is the purpose of this setting? You want to have your visualization updated with the date automatically?

[obriaincian]

@MFelix , Yes I would like todays date(or last weeks date depending on the colum) to be reflected in the column header

[MFelix]

Hi @obriaincian 

Check if this can help https://perytus.com/2021/02/04/improve-ux-show-year-in-legend-when-using-time-intelligence-measures/