Forum Discussion

JChouris's avatar
JChouris
Icon for Helper I rankHelper I
3 years ago
Solved

Order Numbers with Multiple Serial Numbers

Kinda new with a lot of this. I am trying to generate a report to show the serial numbers asscoiated with each order number, for order numbers with multiple serial numbers i want them to all be in one row instead of duplicating the order number throughout the column. I wasnt sure how to go about this so figured i would post. Any help is greatly appreciated. Thank you.

 

 

  • I played with the formula a bit and found the solution. Thank you for you help.

     

     

3 Replies

  • JChouris 

    what about create a measure to combine serailnum?

    Measure = CONCATENATEX('Table','Table'[serialnum],",")

    • JChouris's avatar
      JChouris
      Icon for Helper I rankHelper I

      When i use that it doesnt distinguish between the order numbers and just puts all serial numbers following each other...

       

       

      • JChouris's avatar
        JChouris
        Icon for Helper I rankHelper I

        I played with the formula a bit and found the solution. Thank you for you help.