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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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