Forum Discussion
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...
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])))
The better question here might be then - How do you replicate a SQL GroupBY clause in DAX
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]....
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])))
