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 this.

Thank you!!!

 

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

19 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    4 years ago

    Anonymous 

    maybe you can try this

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

      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_mayu's avatar
        ryan_mayu
        Super User
        4 years ago

        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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    My data source same this