Count number of times called on same date

[Daven]

Hi,

I am looking for some help adding a column to a table.

I need a new column with count of called from on same date. 3rd column is the result I am looking for.

Called From	Date Called	Result wanted (Count called from on same date)
123	11/01/2019	1
123	11/02/2019	1
001	11/01/2019	2
001	11/01/2019	2
002	11/01/2019	3
002	11/01/2019	3
002	11/01/2019	3
002	11/02/2019	1

I have other 10 - 12 columns in the table. (call start and end date, agent answered, Queue called on etc ).

The same caller might receive different agent on the same day or end time might be different. I need to count columns where only called from and called date is duplicate.

Thanks for your help 

Daven

[mwegener]

Hi @Daven ,

so?

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[Daven]

Thanks Marcus 

Sorry I missed adding in the initial post that I have other 10 - 12 columns in the table. (call start and end date, agent answered, Queue called on etc ).

The same caller might receive different agent on the same day or end time might be different. I need to count columns where only called from and called date is duplicate.

Thanks,

Daven

[mwegener · Accepted solution]

Hi @Daven ,

try this.

Column = CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Called From],'Table'[Date Called]))

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.