cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ichebobo Member
Member

Display Total in Month and Year from a date/time field

Hi Everyone,

 

 

I have a call data for different times, days, months, weeks and years.

 

Now I want to be able to display  the total number of calls made in a month and  the total number of calls made in each  year.

 

I have tried using 'count' on the data and it gives me the entire number of all calls in the data. But I want to be be able to just specify and display, 2016 or 2017, or 2018 and get the total for that specific year.

and also another column where I can display total for each of the months.

 

See the data below.

 

 call_time.JPG

 

 

Many Thanks for your help.

 

Ichebobo

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Display Total in Month and Year from a date/time field

Solution is attached.





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




2 REPLIES 2
Highlighted
Super User
Super User

Re: Display Total in Month and Year from a date/time field

Solution is attached.





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.




 




ichebobo Member
Member

Re: Display Total in Month and Year from a date/time field

Many Thanks Parv,

 

Your solution of creating/linking a new column a worked perfectly:

 

Due Date =
VAR mm = VALUE ( MID( 'Call Total'[DueDate], 4, 2 ) )
VAR dd = VALUE ( LEFT( 'Call Total'[DueDate], 2 ) )
VAR yy = VALUE ( MID( 'Call Total'[DueDate], 7, 4 ) )
RETURN
DATE( yy, mm, dd )

 

and 

Total Calls = COUNTROWS( 'Call Total' )