Forum Discussion

space83's avatar
space83
Icon for Helper IV rankHelper IV
4 years ago

make 6 row become 1 row

Hi all,   This 2 table below actually come from same table in model. How can I show the 2nd table (workorder) in table 1 as new column in 1 row and separate by comma?   as example it will be som...
Need Help
Show and Tell
Tips and Tricks
JYA's avatar
JYA
Frequent Visitor
4 years ago

Hi, 

 

you can add a measure of this kind : 

Workorder full = CONTATENATEX('WorkOrder','Workorder'[Workorder], ", ")
Of course you need to filter on same key but you have not provided it in your message.