Forum Discussion

priyaMungara's avatar
priyaMungara
Regular Visitor
9 years ago
Solved

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    ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

priyaMungara's avatar
priyaMungara
Regular Visitor
9 years ago

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

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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