Remove duplicate values separated by a comma in a text string in DAX

[Syndicate_Admin]

Good morning to all

I have a measurement in DAX that returns a string of characters but as the query does from a table with several records made on different dates it returns the text string with repeated values.

This is the Measure:

Pending Approval 2 = CONCATENATEX('Timesheet Pending Date','Timesheet Pending Date'[User],", ")

Example of the result is:

Gabriela Rivera, Gabriela Rivera, Gabriela Rivera, Ivan Callay, Ivan Callay

What I need is to remove the repeated names and leave me the string only with an instanacia for each different value, that is to say that it leaves me as a result this:

Gabriela Rivera, Ivan Callay

I hope you can help me with this.

Thank you very much for your help.

[Syndicate_Admin]

Excellent, thank you very much, it works perfectly

[sevenhills · Accepted solution]

Pending Approval 2 = CONCATENATEX(VALUES('Timesheet Pending Date'[User]),'Timesheet Pending Date'[User],", ")

Try this?