Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

The syntax for ')' is incorrect.

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 f...
return
variable
Anonymous's avatar
Anonymous
Not applicable
3 years ago

I'm getting the same error as a measure.

unicorns's avatar
unicorns
Helper II
3 years ago

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.