topic Concatenation using variables in DAX Commands and Tips

Concatenation using variables

Anonymous — Thu, 19 Jan 2023 18:27:11 GMT

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"
Further, if the State in another table = a certain value, additional concatenate "+zzz'

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.

I've been playing with using variables and concatenations and Related, but no success.

Re: Concatenation using variables

Arul — Sat, 21 Jan 2023 05:14:31 GMT

Anonymous ,

Can you share the sample data?

Thanks,

Re: Concatenation using variables

Anonymous — Tue, 24 Jan 2023 18:26:07 GMT

I'm not certain the best way to share data information. Will the relationship diagram help?

Here is what I've tried to start - I'm trying to create a measure on a donor transaction table checking to see if the donor number is in the CHG table.

TestReq =

var CHG = RELATED(CHAGAS[TIDONR])

RETURN