Forum Discussion
help with table and calculation
Hello
I am having trouble creating a table or chart that can show me how many people called for the same issue 2 times, 3 times and more than 3 times per month (iN jUNE, JULY and the August) . Thank you so much in advance!
Here is a sample data:
data
I was thinking to show something like this:
5 Replies
I added the same table here:
Issue Name Date Person Name
category 1 19-Jul Mavi category 2 19-Jul Jose category 3 19-Jul Miriam category 4 19-Jul Miriam category 5 19-Jul Tom category 5 19-Jul Tom category 5 19-Jul Tom category 5 19-Jul Paul category 1 19-Jun Paul category 2 19-Jun Carla category 3 19-Jun Ana category 4 19-Jun Ana category 4 19-Aug Ana category 4 19-Aug Ana category 6 19-Aug Jose category 6 19-Aug Jose category 6 19-Aug Jose Thank you!!
Anonymous wrote:Hi Anonymous
It'll be much easier if your sample data could be copied and pasted.
Cheers!
AHi Anonymous
Here are the steps for your requirement:
1. Create a month number column.
In edit query mode, add a new column and type this code
Date.Month([Date])
2. Add an index column. Under add column menu item, press add index. This is just to show all rows with duplicates.
3. Create a new custom column. DAX is:
Count = CALCULATE ( COUNTROWS ( T25 ), FILTER ( T25, T25[Issue] = EARLIER ( T25[Issue] ) ), FILTER ( T25, T25[Month Number] = EARLIER ( T25[Month Number] ) ) )Now, you have the table with the relevant counter.
First SolutionNot sure if you want to count individuals or a general number of calls.
Anyhow, I think this is 90% of the solution if not a whole one.
Cheers!
A