Forum Discussion
The syntax for ')' is incorrect
Hello
I'm created new table in Power BI
this message error "The syntax for ')' is incorrect" view
when i use NATURALINNERJOIN or any Functions to fill data in column
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
10 Replies
I'm created new table in Power BI
this message error "The syntax for ')' is incorrect" view
when i use NATURALINNERJOIN or any Functions to fill data in column
can you help me
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
Hi syz,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
