Forum Discussion
Comma Separator
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
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
arav007 You can use CONCTENATEX
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
