cancel
Showing results for 
Search instead for 
Did you mean: 

Childless

Super User
361 Views
Highlighted
Super User
Super User

Childless

The goal of this Quick Measure is to identify rows, in this case emails in email threads, that have no replies (children). Thus, these rows identify the last email in a thread of emails.

 

 

Childless = VAR __table = ALL('Emails')
VAR __table1 = ADDCOLUMNS(__table,"__count",COUNTX(FILTER(__table,[parentactivityid]=EARLIER(Emails[emailid]) && [createdon]>EARLIER([createdon])),[emailid]))
VAR __table2 = FILTER(__table1,[__count]<1)
RETURN
CONCATENATEX(__table2,[emailid],",")

 

 


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!