Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
  • ryan_mayu's avatar
    4 years ago

    Anonymous 

    maybe you can try this

    Measure = CONCATENATEX(values('Table'[farbric code]), 'Table'[farbric code],",")
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    I missed this reply.

    maybe you can try to change to ISFILTERED('Table'[month])

    changed the doc column to month column