Forum Discussion

Resolver I

3 years ago

Solved

Dynamic header in calculated table

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
3 years ago
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.

MFelix
Super User
3 years ago
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.
MFelix
Super User
3 years ago
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
  Resolver I
  3 years ago
  MFelix , Yes I would like todays date(or last weeks date depending on the colum) to be reflected in the column header
  - MFelix
    Super User
    3 years ago
    Hi obriaincian
    
    Check if this can help https://perytus.com/2021/02/04/improve-ux-show-year-in-legend-when-using-time-intelligence-measures/
obriaincian
Resolver I
3 years ago
MFelix Thank you for the suggestion but I'm looking to see if column headers can be dynamic rather than legends in a visual