cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
AClerk Member
Member

Create a list of values with same ID

Edit the edit:
Solved the duplications as well.

 

EDIT:
I have solved the issue, but now, when I join the table based on the EMP_ID, I have duplications.

How can I avoid those?

 

Original -->

Hi All,
I am trying to get all values related to the same ID.

For example I have employee id and end dates. EMP_ID is not unique in this table.
I would like to create a calculated columne with all end dates related to the same employee id (List_of_End_Dates),

 

EMP_IDEND_DATEMore_ColumnsList_of_End_Dates
11/02/2019?1/02/2019; 6/03/2019
25/06/2018?5/06/2018; 18/01/2019
319/03/2019?19/03/2019
16/03/2019?1/02/2019; 6/03/2019
42/02/2019?2/02/2019
218/01/2019?5/06/2018; 18/01/2019
93/04/2019?3/04/2019
1521/04/2019?21/04/2019

 

How is that possible?

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
AClerk Member
Member

Re: Create a list of values with same ID

Managed to achieve this:

List = CALCULATE(CONCATENATEX('Table','Table'[end_date],"; "), ALLEXCEPT('Table','Table'[EMP_id]))

Seems to work Smiley Happy

 

Cat LOL

 

 

1 REPLY 1
AClerk Member
Member

Re: Create a list of values with same ID

Managed to achieve this:

List = CALCULATE(CONCATENATEX('Table','Table'[end_date],"; "), ALLEXCEPT('Table','Table'[EMP_id]))

Seems to work Smiley Happy

 

Cat LOL