Forum Discussion
JChouris
Helper I
3 years agoOrder 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
- ryan_mayu
Super User
what about create a measure to combine serailnum?
Measure = CONCATENATEX('Table','Table'[serialnum],",")