Forum Discussion

stackedcreative's avatar
stackedcreative
Frequent Visitor
5 years ago

Grouping DocID Column to show all data points

Hi.  I have a unique DocID column.  There are 4 separate workflows for each DocID (Create, HR Process, Package Selection, Service Process).  Problem is, they are in separate rows.  I need to show the...
Need Help
DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
5 years ago

You can adjust the second argument to include multiple columns, like this:

 

Concat = CONCATENATEX ( DocTable, DocTable[WFAction] & " = " & DocTable[JoinDate], ", " )

 

 

stackedcreative's avatar
stackedcreative
Frequent Visitor
5 years ago

DataInsights - FINALLY had time to work on this.  I need the data to still be in separate columns.  I ran this and got about 6,000 pieces of data in one... makes it hard to put in something readable.  

 

I tried UNION, have looked into other stuff.  Still perplexed.