Count of email threads by month

[TG_12]

Hi,  I have connected a shared customer service request mailbox to PowerBI. This mailbox is used to answer cutomer requests - these can contain back and forth emailing within the one request resulting in alot of emails under one email thread/subject. What I am trying to do is create a card and a graph showing the number of requests recieved per month (not the total emails but total requests i.e. if there were 3 emails as part of one request just count this as 1). However I want this count to only count a request in the first month it recieved. E.g. a request was recieved on the 30th January and the back and forward emailing continued throught February - I want the count to only show this request in the count for January and not be included in February.  been tryng to get this set up but I am stuck - Is something like this possible?  Thanks

[amitchandak · Accepted solution]

@TG_12 , Assume you have request ID and request Date a new column

count 1 only for the first 30th day

New Column =

var _min = minx(filter(Table, [RequestID] =earlier([RequestID])) , [RequestDate]) )

return

Switch(True(),

[RequestDate] =_min, [RequestID],

[RequestDate] <=_min+30,Blank() ,

[RequestID]

)

Count only once

New Column =

var _min = minx(filter(Table, [RequestID] =earlier([RequestID])) , [RequestDate]) )

return

Switch(True(),

[RequestDate] =_min, [RequestID],

blank()

)

[TG_12]

The count only once measure worked perfectly. Thank you!