Forum Discussion
The syntax for ')' is incorrect.
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.
I'm getting the same error as a measure.
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+zzzyyy and zzz are not present in any table, just text values to concatenate.