Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
100 | |
98 | |
88 | |
70 |
User | Count |
---|---|
166 | |
131 | |
129 | |
102 | |
98 |