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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
TG_12
Frequent Visitor

Count of email threads by month

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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()

)

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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()

)

The count only once measure worked perfectly. Thank you! 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.