Forum Discussion
Comma separated list
Hi all, I am having trouble processing data in power BI. Can you help me make all of FABRIC CODE each OUT DOCUMENT become a row (the fabric code a comma separated list). I am very grateful for th...
Anonymous
maybe you can try this
Measure = CONCATENATEX(values('Table'[farbric code]), 'Table'[farbric code],",")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
Measure = CONCATENATEX(values('Table'[farbric code]), 'Table'[farbric code],",")
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?
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?
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