Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to 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
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
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
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
the formula is cost = var HealthCost = NATURALINNERJOIN(Projects,ProjectBaselines)
Are you sure you are trying to create a new table and then using this formula to create the table 'cost'?
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
Can you share the sample data? Because I guess the problem lies in the columnname or table.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
122 | |
109 | |
60 | |
55 |