Forum Discussion
The syntax for ')' is incorrect.
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?
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.