Forum Discussion

Naverie's avatar
Naverie
Icon for Helper I rankHelper I
5 years ago

Dynamic column headings - based on todays date

Hi,   I'm really hoping this is possible.  In an SSRS report we were able to code the column headings so they are dynamic based on todays date. I'm wanting to do the same in a table (it can be a m...
Date
DAX
Dynamic
Dynamic Column
Table
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

Naverie Only way I can think of is to have your table headers in a disconnected (maybe connected) table so that it recalculates at refresh. Then use these columns. So, for example:

Table = 
  DATATABLE(
    "Heading",STRING,
    {
      {"D" & FORMAT(TODAY(),"dd/MM")},
      {"D+1" & FORMAT(TODAY()+1,"dd/MM")},
      {"D+2" & FORMAT(TODAY()+2,"dd/MM")}
    }
  )
Naverie's avatar
Naverie
Icon for Helper I rankHelper I
5 years ago

Greg_Deckler thank you for your response.

 

I've just tried that and am getting this error:

 

The tuple at index '1' from the table definition of the DATATABLE function does not have a constant expression in the column at index '1'.

 

I have pasted it into a measure exactly as it is. Is that correct?

 

Thanks

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Naverie Oh yeah, DATATABLE... Try a straight table constructor:

    Table 4 = 
    {
        "D" & " " & FORMAT(TODAY(),"dd/MM"),
        "D+1" & " " & FORMAT(TODAY()+1,"dd/MM"),
        "D+2" & " " & FORMAT(TODAY()+2,"dd/MM")
    }
    • Naverie's avatar
      Naverie
      Icon for Helper I rankHelper I
      5 years ago

      Greg_Deckler 

      I am having a right mare with this 😂

       

      Am now getting this and the table not loading?

       

      A table with multiple values was supplied where a single value was expected

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        5 years ago

        Naverie The formula is for a table. So you need to go to Modeling tab, click New Table and then enter the formula. This will not work for a column or measure.