Forum Discussion
help with table and calculation
Hi Anonymous
It'll be much easier if your sample data could be copied and pasted.
Cheers!
A
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!
AThank you for your help on this. It's a little close from what I wanted. I was looking into something that can show the counts of patients name that shows up in the list more than 2, 3 and 4 or more times. So for example, if Tom and Jose shows 3 times in the list, then I want a table that shows in one column the count of all the people whose names shows 3 times (in this case 2 people) and then another column that shows how many times each of those names shows in the list (in this case each person shows 3 times). And then the same for those that shows 2 times,and 4 times or more. In power bi I did it with a table visual but it brings me all the names of the people and then it repeats the counts for each name which makes my table pretty long and hard to read.
Something like this:
Count of People Times Called
2 3
- Ashish_Mathur
Super User