Hi Guys,
I have a flat table in PowerBI.
I have a table with a column 'Unique Swap Identifier' and this contains rows of values (FYI some of these values are repeated, some unique)
e.g. in this order
ABC123
ABC123
DEF567
XYZ890
DEF567
etc...
There is another existing column which is titled 'Error Description'
e.g. in this order
Issue 1
Issue 7
Issue 1
Issue 9
Issue 9
etc...
Is it possible to add a new column (at the end) where it concatenates the error description column values based on the Unique Swap Identifier column?
e.g.
On the same row for ABC 123, there would an additional column where it shows the concatenated error descriptions for ABC 123 (e.g. Issue 1 ; Issue 7)
Another example for DEF567 the concat values would be 'Issue 1 ; Issue 9'
Many thanks in advance,
Prinz
I have a flat table in PowerBI.
I have a table with a column 'Unique Swap Identifier' and this contains rows of values (FYI some of these values are repeated, some unique)
e.g. in this order
ABC123
ABC123
DEF567
XYZ890
DEF567
etc...
There is another existing column which is titled 'Error Description'
e.g. in this order
Issue 1
Issue 7
Issue 1
Issue 9
Issue 9
etc...
Is it possible to add a new column (at the end) where it concatenates the error description column values based on the Unique Swap Identifier column?
e.g.
On the same row for ABC 123, there would an additional column where it shows the concatenated error descriptions for ABC 123 (e.g. Issue 1 ; Issue 7)
Another example for DEF567 the concat values would be 'Issue 1 ; Issue 9'
Many thanks in advance,
Prinz