The syntax for ')' is incorrect

Hi syz,

Based on my test, if you want to use the "var" funtion, you need to use the "return" function to return a value with the "var" function.

Reference:https://msdn.microsoft.com/en-us/query-bi/dax/var-dax

Also, you could just use the "NATURALINNERJOIN" function, but make sure that the two tables you want to join should have relationship and it could work on my side.

New table:

New Table = NATURALINNERJOIN('Table1','Table2')

Reference:https://msdn.microsoft.com/en-us/query-bi/dax/naturalinnerjoin-function-dax

You could also download the pbix file to have a view.

https://www.dropbox.com/s/3xobjnpit8mdr8k/The%20syntax%20for%20%27%29%27%20is%20incorrect.pbix?dl=0

Regards,

Daniel He