Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
syz
Regular Visitor

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

1 ACCEPTED SOLUTION
v-danhe-msft
Employee
Employee

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.

2.PNG 

New table:

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

4.PNG

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

10 REPLIES 10
v-danhe-msft
Employee
Employee

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-danhe-msft
Employee
Employee

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.

2.PNG 

New table:

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

4.PNG

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
syz
Regular Visitor

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  

rajulshah
Super User
Super User

Hello @syz,

 

Can you please share the formula you're using to create the table?

 

error report.PNG

the formula is cost = var HealthCost = NATURALINNERJOIN(Projects,ProjectBaselines)

Hello @syz,

 

You can use :

cost = NATURALINNERJOIN(Projects,ProjectBaselines)

 

Hope this helps.

Hi @rajulshah

 

Thanks for the reply.  tried your suggested solution, but it did not work.

Are you sure you are trying to create a new table and then using this formula to create the table 'cost'?

@rajulshah 

Yes, I'm sure,

Note:

I would like to make it clear to you that the name of the new table is cost and  the name of column is  HealthCost 

errorNew colum.PNG

Can you share the sample data? Because I guess the problem lies in the columnname or table.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.