Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

DAX evaluate table : how to remove table name from columns name

Hi,

 

I'm using this great post (https://biinsight.com/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-2-importing-power-bi-data-to-excel-directly) to export table data from Power Bi directly to Excel.

Using EVALUATE 'Table' returns columns named TABLENAME[ColumnName].

Is there a way to get rid of the TABLENAME[] in each column name?

 

Thanks for your help.

 

Sincerely,

 

JM

Need Help

3 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Anonymous,

    I have tested the evaluate function in Dax studio, you could use the formula to test if it could get column data:

    EVALUATE 
	VALUES(Table1[Column1])

     

    I hope it could help you.

     

    Regards,

    Daniel He

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thank you for your answer Daniel.

      Unfortunately, from excel SSAS connection, using EVALUATE VALUES(Table1) still brings Table1[] around the names of the columns.

       

      Reagards,

       

      JM

      • v-danhe-msft's avatar
        v-danhe-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        7 years ago

        Hi Anonymous,

        Based on my test, it could work in the Power BI Desktop, you could refer to below picture:

        Could you have tried the code EVALUATE VALUES( your table [your column]) instead of the code EVALUATE VALUES(your table)?

        I suggest you try again.

         

        Regards,

        Daniel He