Forum Discussion
Comma separated list
- 4 years ago
Anonymous
maybe you can try this
Measure = CONCATENATEX(values('Table'[farbric code]), 'Table'[farbric code],",") - 4 years ago
I missed this reply.
maybe you can try to change to ISFILTERED('Table'[month])
changed the doc column to month column
Anonymous
maybe you can try this
Yes, thank you!
I have done it before. However, my source data contained a lot of rows... and they outputted everything.
Do you have any other way?
- ryan_mayu4 years agoSuper User
do you mean duplicated fabric code?
i tried to reproduce the situation, the measure does not combine the repeate fabric code.
could you pls provide the sample data?
- Anonymous4 years agoNot applicable
the same this...
Data row is very large. Looks like I need to filter them before using CONCATENATEX... but I don't know how to make
- ryan_mayu4 years agoSuper User
Anonymous
still can't reproduce the issue.
is it possbile to share the pbix file after removing sensitive data?
- Anonymous4 years agoNot applicable
Wow, that is result of your formula... only it doesn't follow OUT DOCUMENT
- ryan_mayu4 years agoSuper User
you need to remove the " farbric doe customer " column
- Anonymous4 years agoNot applicable
Oh Yes I made it... Woww... thank you, thank you so much 😘
- ryan_mayu4 years agoSuper User
you are welcome