Forum Discussion
duplicate entries for consecutive days
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
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
2 Replies
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
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
