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...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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],","))

  

ryan_mayu's avatar
ryan_mayu
Super User
4 years ago

you can also try this

 

Measure = if(HASONEVALUE('Table'[doc]),CONCATENATEX(VALUES('Table'[fabric code]),'Table'[fabric code],","))