Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
cnoh
Frequent Visitor

How to find a distinguished value in a column

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.

 

cnoh_0-1746717839278.png

 

1 ACCEPTED SOLUTION
v-achippa
Community Support
Community Support

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

View solution in original post

3 REPLIES 3
v-achippa
Community Support
Community Support

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

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

maruthisp
Super User
Super User

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.