Forum Discussion

sivasrao's avatar
sivasrao
Icon for Helper III rankHelper III
3 years ago
Solved

Rename the column headers in new table

Hi, As all of you know the creation of a new table by using the DAX function.  It's like  Table = {("first name", "second name")} we will get a new table with column headers as "value1" and "val...
Need Help
Show and Tell
Tips and Tricks
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi sivasrao 

     

    try to create a table with this:

    Table =
    DATATABLE(
        "FirstName", STRING,
        "SecondName", STRING,
        {
            {"Michael", "Johnson"},
            {"Michael", "Jordan"},        
            {"Michael", "Phelps"}
        }
    )
     
    I tried and it worked like this:

     

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi sivasrao 

 

try to create a table with this:

Table =
DATATABLE(
    "FirstName", STRING,
    "SecondName", STRING,
    {
        {"Michael", "Johnson"},
        {"Michael", "Jordan"},        
        {"Michael", "Phelps"}
    }
)
 
I tried and it worked like this:

 

  • sivasrao's avatar
    sivasrao
    Icon for Helper III rankHelper III
    3 years ago

    Thank you for your quick reply.

    But, is there any chance or other option to rename those column headers?

    • FreemanZ's avatar
      FreemanZ
      Icon for Super User rankSuper User
      3 years ago

      try not to do that with DAX. try to do it in datasource.