duplicate entries for consecutive days

[priyaMungara]

I have two columns  - id and date(some consecutive days). 

ID  date

1    08/03/17

1    08/04/17

2     08/03/17

2    08/04/17

3   08/03/17

3   08/04/17

What I want to find out is 

08/03/17 - 3 (distinct count of ids)

               -  0 (distinct count of ids that are in common with today and previous day)

08/04/17 -3 (distinct count of ids)

               -  2 (distinct count of ids that are in common with today and previous day)

Please do let me know if there is any way to do this

[priyaMungara]

I have two columns  - id and date(some consecutive days). 

ID  date

1    08/03/17

1    08/04/17

2     08/03/17

2    08/04/17

3   08/03/17

3   08/04/17

What I want to find out is 

08/03/17 - 3 (distinct count of ids)

               -  0 (distinct count of ids that are in common with today and previous day)

08/04/17 -3 (distinct count of ids)

               -  2 (distinct count of ids that are in common with today and previous day)

Please do let me know if there is any way to do this

[v-shex-msft · Accepted solution]

Hi @priyaMungara

Not very sure for your calculate steps.
On my side, I get the different analysis result.

Summary table:

Table = ADDCOLUMNS(SUMMARIZE('sample',[date],"Distict ID",COUNTROWS(VALUES('sample'[ID]))),"Previous",CALCULATE(COUNTROWS(VALUES('sample'[ID])),'sample'[date]<EARLIER('sample'[date]))+0)

Regards,

XIaoxin Sheng