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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
Microsoft Employee
Microsoft 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
Microsoft Employee
Microsoft 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
Microsoft Employee
Microsoft 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.