Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 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 dir...
Need Help
v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 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
7 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