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
turn off the total
or
update the DAX
Measure = if(ISFILTERED('Table'[DOC]), CONCATENATEX(VALUES('Table'[farbic code]),'Table'[farbic code],","))I don't know why I use this formula it's not run
Measure = if(ISFILTERED('Table'[DOC]), CONCATENATEX(VALUES('Table'[farbic code]),'Table'[farbic code],","))
you are welcome
I missed this reply.
maybe you can try to change to ISFILTERED('Table'[month])
changed the doc column to month column
you can also try this
Measure = if(HASONEVALUE('Table'[doc]),CONCATENATEX(VALUES('Table'[fabric code]),'Table'[fabric code],","))It's okay... thank you so much!!!