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

Question

Hi,&nbsp;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&nbsp;TABLENAME[] in each column name?&nbsp;Thanks for your help.&nbsp;Sincerely,&nbsp;JM

v-danhe-msft · Answer

Hi&nbsp;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])

&nbsp;
I hope it could help you.
&nbsp;
Regards,
Daniel He

anonymous · Answer

Thank you for your answer Daniel.Unfortunately, from excel SSAS connection, using&nbsp;EVALUATE VALUES(Table1) still brings Table1[] around the names of the columns.&nbsp;Reagards,&nbsp;JM

v-danhe-msft · Answer

Hi&nbsp;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&nbsp;EVALUATE VALUES( your table [your column]) instead of the code EVALUATE VALUES(your table)?
I suggest you try again.
&nbsp;
Regards,
Daniel He

Forum Discussion

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

3 Replies

Related content

Lazy evaluation

Remove Blank Columns

Remove Matrix Table Column Title

Remove circular dependency from calculated column

Dataflow evaluation error