Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

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

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 re...
  • sevenhills's avatar
    sevenhills
    4 years ago
    Pending Approval 2 = CONCATENATEX(VALUES('Timesheet Pending Date'[User]),'Timesheet Pending Date'[User],", ")
     
    Try this?
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Excellent, thank you very much, it works perfectly