Forum Discussion

priyaMungara's avatar
priyaMungara
Regular Visitor
8 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
    8 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
8 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
    8 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