topic Re: The syntax for ')' is incorrect. in DAX Commands and Tips

The syntax for ')' is incorrect.

Anonymous — Fri, 20 Jan 2023 16:27:38 GMT

I've searched for this and the typical suggestion is that the Return is needed. I'm using this in a new column, does it need to be a measure? What is the issue? I need to have a few of these but figured I'd get one right first.

Re: The syntax for ')' is incorrect.

AnthonyJoseph — Fri, 20 Jan 2023 16:38:49 GMT

Hi Anonymous Return funtion consumes variables.

TestReq = var Chag = Relatedtable(CHAGAS) Return Chag

This solution might help you to understand better https://community.powerbi.com/t5/Desktop/How-DAX-Execute-VAR-RETURN/m-p/654960

Re: The syntax for ')' is incorrect.

unicorns — Fri, 20 Jan 2023 16:53:11 GMT

Hi GQ,

Can you try returning the variable you have created?

TestReq =

var CHAG = RELATEDTABLE(CHAGAS)

RETURN CHAG

You can define a variable in any DAX expression by using VAR followed by RETURN. In one or several VAR sections, you individually declare the variables needed to compute the expression; in the RETURN part you provide the expression itself (Source: SQLPBI)

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, and Kudos 👍 are very much appreciated!

- YJ

Re: The syntax for ')' is incorrect.

Anonymous — Fri, 20 Jan 2023 16:47:07 GMT

I got a new error.

@AnthonyJoseph - the link did not work

unicorns

Re: The syntax for ')' is incorrect.

Anonymous — Fri, 20 Jan 2023 16:50:40 GMT

AnthonyJoseph - I got it to work from the email I received.

Re: The syntax for ')' is incorrect.

unicorns — Fri, 20 Jan 2023 17:01:48 GMT

Hi GQ,

I just read your post again and if you are trying to use this in a 'new column' then it should be a measure. I think that formula is returning an entire table, which you can't use for a column since it's returning multiple columns.

you should assign your code to a measure in this case. I think you can use filters+aggregate functions in your code to ensure you are returning a measure instead of entire table. let me know if I can help.

Re: The syntax for ')' is incorrect.

Anonymous — Fri, 20 Jan 2023 17:38:38 GMT

I'm getting the same error as a measure.

Re: The syntax for ')' is incorrect.

unicorns — Fri, 20 Jan 2023 17:46:52 GMT

Are you able to share a pbi file or information/logic on what kind of measure you are trying to create for that new column?

Re: The syntax for ')' is incorrect.

Anonymous — Fri, 20 Jan 2023 17:52:04 GMT

I created another post yesterday, I think, that may help you understand where I'm going. It said (with notations added now):

I need to have a result column in my report be a concatenation of text and conditionally, 1 or 2 addtional text 'values'.

Donor+xxxx - in every row
conditionally, if donor # from table 1 matches a donor # from table 2, I need to concatenate "+yyy" - this would be CHAG
Further, if the State in another table = a certain value, additional concatenate "+zzz' This, I was hoping would be another var situation.

Both the yyy & zzz are optional

End results could be any of:
Donor+xxxx
Donor+xxxx+yyy
Donor+xxxx+zzz
Donor+xxxx+yyy+zzz

yyy and zzz are not present in any table, just text values to concatenate.

Re: The syntax for ')' is incorrect.

tamerj1 — Fri, 20 Jan 2023 18:20:37 GMT

Hi Anonymous

which column from that table would you like to return? What is the relationship between the two tables?

Re: The syntax for ')' is incorrect.

tamerj1 — Fri, 20 Jan 2023 18:20:38 GMT

Hi Anonymous

which column from that table would you like to return? What is the relationship between the two tables?

Re: The syntax for ')' is incorrect.

Anonymous — Fri, 20 Jan 2023 18:55:24 GMT

I want to return the 1st column which is a member number. It is unique and it linked to another table by that number. Essentially, if the member is not in that table, I need to concatenate another literal to a message column. (see my reply to unicorn in this thread with my needed logic.)