Forum Discussion

carrl284's avatar
carrl284
Frequent Visitor
5 years ago
Solved

DAX Measure to Concatenate Unique Strings

Hi, I have a table where people have worked dates on a job.  The start and end columns are split to a row for each day. This results in the comments being duplicated for every day. Can anyone show m...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, carrl284 

    Please try the link down below.

     

     

    Comments =
    IF (
    ISFILTERED ( 'Table'[EmployeeId] ),
    CONCATENATEX (
    SUMMARIZE (
    FILTER ( ALL ( 'Table' ), 'Table'[EmployeeId] = MAX ( 'Table'[EmployeeId] ) ),
    'Table'[Comment]
    ),
    'Table'[Comment],
    ", "
    )
    )
     
     

    Hi, My name is Jihwan Kim.


    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.


    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

Anonymous's avatar
Anonymous
Not applicable
5 years ago

carrl284 can you try pivoting your date columns and your employeeid should be the column name and you should return your comments while pivoting, that way we get the comments on the corresponding days in a row for an employee, you will eliminate the duplicates which you have shown in your image. Then you can try your concatenate DAX, you might get blanks using this method that you can take care of I believe.

 

 

Please mark this as solution, if I helped you well.

 

Thanks

carrl284's avatar
carrl284
Frequent Visitor
5 years ago

Hi Anonymous Thanks for the quick response.  In my actual model there is a lot more going on so I don't think I could face reshaping the data model now.