Comma Separator

[arav007]

I need to get F2=Test3,Test4

o/p to get

F1	R1	F2
G1	Preparer	Test3,test4

I need to write a measure for F2 ,Here we can see for F1 and R1 -G1 and preparer is replicating, so output should be get in a single row like

[v-yanjiang-msft · Accepted solution]

Hi @arav007 ,

Has your problem solved by @Greg_Deckler 's solution?

I provide a sample to clarify:

Create a measure:

Measure =
CONCATENATEX ( 'Table', 'Table'[F2], "," )

Get the result.

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@arav007 You can use CONCTENATEX