Create a list of values with same ID

[Anonymous]

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_ID	END_DATE	More_Columns	List_of_End_Dates
1	1/02/2019	?	1/02/2019; 6/03/2019
2	5/06/2018	?	5/06/2018; 18/01/2019
3	19/03/2019	?	19/03/2019
1	6/03/2019	?	1/02/2019; 6/03/2019
4	2/02/2019	?	2/02/2019
2	18/01/2019	?	5/06/2018; 18/01/2019
9	3/04/2019	?	3/04/2019
15	21/04/2019	?	21/04/2019

How is that possible?

Thanks!

[Anonymous · Accepted solution]

Managed to achieve this:

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

Seems to work 🙂