How to find a distinguished value in a column

[cnoh]

Hello all,

I would like to pull a distinct value in the ssubject column.  As you see can see the screenshot below, in a ssubject column, some have duplicate message title. If you see the column to the left, you can see some are replied.  I need to calculate how many days it took to reply to a message.  How can I pull the distinguished subject/value so I can calculate accordingly and not counting the duplicate messages.

[v-achippa · Accepted solution]

Hi @cnoh,

Thank you for reaching out to Microsoft Fabric Community.

To calculate how many days it took to reply per unique message, first remove duplicates based on the ssubject column, keeping only the first row to retain the original message. Then merge this duplicated table with the original table by matching on the ssubject column and in the second table filter where status = ‘Replied’. Expand the date column and name it as ‘ReplyDate’ and calculate the number of days between original message date and reply date.

This ensures duplicates are ignored and only one reply is tracked per conversation.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa

[cnoh]

Thank you!  I think it worked 😊  It looks good for far on my end.

[maruthisp]

Hi,

Am I the only one not able to see images in the posts? I couldn't find the images in the above post and also I can't see when I put images in the post after posting/replying. It is difficult to understand the context sometimes and images can help easily what the problem is.
Strange???
Best Regards,
Maruthi