Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to 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 , 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!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
87 | |
67 | |
49 |
User | Count |
---|---|
135 | |
113 | |
100 | |
68 | |
67 |