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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Giant_Pygmy
New Member

Figuring counts based on time frame.

So I figured this would be simple but the answer has alluded me.   I have a table that holds call informaiton.   One column is for the Telephone Number of the caller, one is the Queue the caller called into, and one is the Date the call took place.   What I'm needing to do is find a way to count how many times a customer called back in within a three week period.  So essentially if a customer had 2 or more calls happen within a three week period count it, otherwise exclude it.  I haven't figured out how to accurately count only calls that have happend twice or more.  I finally figured out how to count calls between dates but not sure if this is the correct path since this will count all calls instead of just the multiple onces.  (BeginDate and EndDate are just datediff 3 weeks from all date in either direction)

 

TestingMeasure:=CALCULATE(COUNTROWS(F_QUEUE_CALL_DETAIL),FILTER(F_QUEUE_CALL_DETAIL, ([BeginDate] <= LASTDATE(D_DATE[Date])
&& [EndDate]>= FIRSTDATE(D_DATE[Date]))))

3 REPLIES 3
Giant_Pygmy
New Member

The goal is to identify if a tel# has called back in within a certain timeframe (3 weeks) and if it has then to count it.  Ultimately this will be used to figure out a resolution effectiveness KPI.  The theory is if a customer had to call back in then the issue was not resolved.

 

Sample Data

CallDatePhonePhoneQueue
1/1/2019789-555-0184CustService
1/1/2019344-555-0181Billing
1/1/2019264-555-0164TechSupport
1/1/2019727-555-0190Billing
1/1/2019273-555-0181TechSupport
1/1/2019429-555-0145CustService
1/1/2019334-555-0146CustService
1/1/2019927-555-0198CustService
1/1/2019221-555-0141CustService
1/1/2019539-555-0142CustService
1/2/2019206-555-0195Billing
1/2/2019250-555-0127Billing
1/2/2019661-555-0168CustService
1/2/2019426-555-0181CustService
1/2/2019159-555-0190Billing
1/2/2019292-555-0128TechSupport
1/2/2019987-555-0126CustService
1/3/2019397-555-0144Billing
1/3/2019119-555-0144Billing
1/3/2019652-555-0115CustService
1/3/2019383-555-0111CustService
1/3/2019752-555-0187TechSupport
1/3/2019428-555-0176TechSupport
1/3/2019884-555-0193CustService
1/3/2019773-555-0182CustService
1/3/2019542-555-0164Billing
1/3/2019941-555-0155Billing
1/3/2019140-555-0143CustService
1/3/2019945-555-0112Billing
1/3/2019539-555-0182Billing
1/4/2019889-555-0176CustService
1/4/2019859-555-0173CustService
1/4/2019119-555-0167Billing
1/4/2019115-555-0113Billing
1/4/2019937-555-0136CustService
1/4/2019680-555-0192CustService
1/4/2019219-555-0126Billing
1/4/2019839-555-0198TechSupport
1/4/2019551-555-0155CustService
1/4/2019188-555-0152Billing
1/4/2019767-555-0151CustService
1/4/2019394-555-0176Billing
1/4/2019820-555-0166Billing
1/4/2019358-555-0188CustService
1/4/2019819-555-0186CustService
1/5/2019175-555-0198TechSupport
1/5/2019752-555-0185TechSupport
1/5/2019572-555-0156CustService
1/5/2019138-555-0156CustService
1/5/2019143-555-0113Billing
1/5/2019147-555-0192Billing
1/5/2019835-555-0116CustService
1/5/2019722-555-0169Billing
1/5/2019576-555-0171Billing
1/5/2019156-555-0187CustService
1/5/2019706-555-0140CustService
1/5/2019754-555-0134Billing
1/5/2019899-555-0134Billing
1/5/2019169-555-0178CustService
1/5/2019698-555-0183CustService
1/5/2019429-555-0145CustService
1/5/2019916-555-0137Billing
1/5/2019158-555-0188TechSupport
1/5/2019362-555-0121CustService
1/6/2019539-555-0121Billing
1/6/2019962-555-0144CustService
1/6/2019716-555-0123Billing
1/6/2019674-555-0188Billing
1/6/2019186-555-0135CustService
1/6/2019847-555-0151CustService
1/6/2019425-555-0158TechSupport
1/6/2019185-555-0190TechSupport
1/6/2019691-555-0149CustService
1/6/2019834-555-0132CustService
1/6/2019962-555-0112Billing
1/6/2019753-555-0179Billing
1/6/2019554-555-0124CustService
1/6/2019156-555-0187CustService
1/6/2019252-555-0127Billing
1/6/2019581-555-0172Billing
1/6/2019153-555-0114CustService
1/6/2019957-555-0125CustService
1/6/2019941-555-0155Billing
1/6/2019329-555-0183Billing
1/6/2019475-555-0188Billing

A couple sample ideas on how to flag those telephone numbers:

 

Month/QueTelNumberDupFlag
Jan  
CustService  
 429-555-01451
 156-555-01871
Billing  
 941-555-01551

 

QueueJan
CustService94%
Billing98%
TechSupport92%
v-xicai
Community Support
Community Support

Hi @Giant_Pygmy ,

 

I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

 

Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.

 

Best Regards,

Amy

 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors