cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

How To Calculate Average number of Calls in a Day and month?

Hi All, I'm a beginner and fairly new to the world of Power BI.

 

I wanted to calculate the average number of calls by person in a Day and Month

 

I have the dates of the calls by person but wanted to know how I can calculate the average. For example, I know that Person A completed 1000 calls in the year 2016 but how can I calculate the average number of calls by day? Also by month.

 

I would sincerely appreciate any help that can be offered. 

 

Thanking everyone in advance. 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: How To Calculate Average number of Calls in a Day and month?

Hi @arslanmithani,

 

If I understand you correctly, you should be able to follow steps below to get your expected result.

 

I assume you have a table called "Table1" like below.

 

t1.PNG

 

1. Use the formula below to create a new calculate column in the table.

Call completed YearMonth = YEAR(Table1[Call Completed Date]) & "-" & MONTH(Table1[Call Completed Date])

c1.PNG

 

2. Use formulas below to create 5 measures.

Total Calls = COUNTROWS(Table1)
Number of Days = DISTINCTCOUNT(Table1[Call Completed Date])
Number of Months = DISTINCTCOUNT(Table1[Call completed YearMonth])
Average Calls Per Day = DIVIDE([Total Calls],[Number of Days])
Average Calls Per Month = DIVIDE([Total Calls],[Number of Months])

3. Just show the measures with "Call Completed by" column (names of person) on the Table visual.

 

r1.PNG

Here is the sample pbix file for your reference. Smiley Happy

 

 

Regards

View solution in original post

4 REPLIES 4
Highlighted
Microsoft
Microsoft

Re: How To Calculate Average number of Calls in a Day and month?

Hi @arslanmithani

 

Could you please post a small mock up of your data so we can suggest some measures that will work for you.

 

One lazy approach is to just sum the calls per person and divide by 365 days, but you probably only want to count days the person was active.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Highlighted
Frequent Visitor

Re: How To Calculate Average number of Calls in a Day and month?

 

 

 

 

Thank you for the quick reply. AttachedDataset.JPG you will find a sample of the dataset (it has the person in Column A and the Date of call completed in Column B). What I need help with is calculating the average number of calls per day by person, and also the aveage number of calls per month by person.

 

 

Highlighted
Microsoft
Microsoft

Re: How To Calculate Average number of Calls in a Day and month?

Hi @arslanmithani,

 

If I understand you correctly, you should be able to follow steps below to get your expected result.

 

I assume you have a table called "Table1" like below.

 

t1.PNG

 

1. Use the formula below to create a new calculate column in the table.

Call completed YearMonth = YEAR(Table1[Call Completed Date]) & "-" & MONTH(Table1[Call Completed Date])

c1.PNG

 

2. Use formulas below to create 5 measures.

Total Calls = COUNTROWS(Table1)
Number of Days = DISTINCTCOUNT(Table1[Call Completed Date])
Number of Months = DISTINCTCOUNT(Table1[Call completed YearMonth])
Average Calls Per Day = DIVIDE([Total Calls],[Number of Days])
Average Calls Per Month = DIVIDE([Total Calls],[Number of Months])

3. Just show the measures with "Call Completed by" column (names of person) on the Table visual.

 

r1.PNG

Here is the sample pbix file for your reference. Smiley Happy

 

 

Regards

View solution in original post

Highlighted
Regular Visitor

Re: How To Calculate Average number of Calls in a Day and month?

Big thx for examples, You made my day 😉

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors