Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

CONCATENATEX is providing duplicated result even when using values() ,distinct() or related table()

Hi ,  Can someone help me with this issue, While concatenating data in one single colum into row wise data, duplicates are coming, is there any way to achieve this without duplicates? I have tried w...
Need Help
  • davehus's avatar
    davehus
    4 years ago

    Hi Anonymous ,

     

    Try this 

    CONCATENATEX(VALUES('# test_DRIVER_DASHBOARD'[CATEGORY]) ,'# test_DRIVER_DASHBOARD'[CATEGORY],",")
    Values will read the column and return a unique set of data.
     
    If this answers your question, please accept my solution.
davehus's avatar
davehus
Memorable Member
4 years ago

Hi Anonymous ,

 

Try this 

CONCATENATEX(VALUES('# test_DRIVER_DASHBOARD'[CATEGORY]) ,'# test_DRIVER_DASHBOARD'[CATEGORY],",")
Values will read the column and return a unique set of data.
 
If this answers your question, please accept my solution.
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi davehus,
    Thank you so much this solved my problem 😁.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi davehus,
    Thank you so much this solved my problem .