Cumulative count of dates in Column

[Anonymous]

Hi there

I have a table of Person and Date In setup in PBI as below.

May I know how can I add a calculated column which returns the count of 'Date In' for each day.

Thanks!

Person	Date In	Cumulative In
A	6-Jan-19	3
B	6-Jan-19	3
C	6-Jan-19	3
D	7-Jan-19	2
E	7-Jan-19	2
F	8-Jan-19	1
G	9-Jan-19	2
H	9-Jan-19	2

[Zubair_Muhammad · Accepted solution]

 @Anonymous

Try

=calculate(Countrows(Table1),allexcept(Table1,Table1[Date In]))