Forum Discussion

ashuaswinireddy's avatar
ashuaswinireddy
Helper I
3 years ago
Solved

How to remove duplicates from calculated column

I have a calculated column which was created using RELATEDTABLE NAMES= CALCULATE(CONCATENATEX(RELATEDTABLE('TABLE'), [NAME],     "," )) What I currently have ID NAMES(CALCULATED COLUMN)...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • vicky_'s avatar
    vicky_
    3 years ago

    Try something like:

    Unique IDs = CONCATENATEX(
    DISTINCT(SELECTCOLUMNS(RELATEDTABLE('Table'), "values", 'Table'[Value])), 
    [values], 
    ", "
)

     

vicky_'s avatar
vicky_
Super User
3 years ago

Try something like:

Unique IDs = CONCATENATEX(
    DISTINCT(SELECTCOLUMNS(RELATEDTABLE('Table'), "values", 'Table'[Value])), 
    [values], 
    ", "
)