Calculated column for repeated customers

[Anonymous]

Hi,

I'm having a bid of hard time figuring something out. I have a table with rows of customers id's who called to the office. Every customer ID is unique per customer, this data is combined with a date. 

I want to create a measure or calculated colmun that counts how many calls are repeated calls within one month without duplication of repeated calls. Is this possible?

For example: 

ID	DATE OF CALL	NUMBER of Repeated calls within one month before without duplication:
1	1-1-2022	0
1	30-1-2022	1
1	12-2-2022	1
2	1-1-2022	0
2	15-1-2022	0
2	25-1-2022	2
3	1-1-2022	0
3	1-2-2022	0
3	1-3-2022	0

[amitchandak · Accepted solution]

@Anonymous , a new column

new column =
var _date = eomonth([DATE OF CALL],0)
var _cnt = countx(filter(Table, [DATE OF CALL] <earlier([DATE OF CALL]) && eomonth([DATE OF CALL],0) = _date && [ID] =earlier([ID])),[ID])
return
if(Isblank(_cnt) ,0,1)