The syntax for ')' is incorrect

[syz]

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

[v-danhe-msft]

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

[v-danhe-msft · Accepted solution]

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

[syz]

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]

Hello @syz,

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

[syz]

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

[rajulshah]

Hello @syz,

You can use :

cost = NATURALINNERJOIN(Projects,ProjectBaselines)

Hope this helps.

[syz]

Hi @rajulshah, 

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

[rajulshah]

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

[syz]

@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 

[rajulshah]

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