Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Get First and Last Date from Group

I have imported an Outlook Mail box and I want to flag the first and last email in a conversation. I have started by normalising the subject by removing FW: and RE: so I can group the emails by subj...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Just incase anyone googles this in the future and needs the answer - here you go:

     

    Earliest = Calculate(min(Mail[DateTimeReceived]),filter(mail,Mail[subject]=earliest(Mail[Subject])))

    And

    Latest = Calculate(max(Mail[DateTimeReceived]),filter(mail,Mail[subject]=earliest(Mail[Subject])))

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I am now trying the following moving away from the Filter

StartDate = CALCULATE(MIN(Mail[DateTimeReceived]),Groupby(Mail,Mail[Subject]))
 
But now I get a circular dependency on mail[startdate]....
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Just incase anyone googles this in the future and needs the answer - here you go:

 

Earliest = Calculate(min(Mail[DateTimeReceived]),filter(mail,Mail[subject]=earliest(Mail[Subject])))

And

Latest = Calculate(max(Mail[DateTimeReceived]),filter(mail,Mail[subject]=earliest(Mail[Subject])))