Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Counter by date

Hello,

 

I need a counter of visits by shop by day. The counter only goes up if the shop was visited on another day, so not on the same day. I don't see how...

 

DateShopVisit counter
27/03/2019Shop 11
27/03/2019Shop 21
27/03/2019Shop 11
27/03/2019Shop 31
27/03/2019Shop 11
28/03/2019Shop 12
29/03/2019Shop 13
30/03/2019Shop 14
30/03/2019Shop 22
30/03/2019Shop 32

 

Thank you!

 

Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi Anonymous 

    Try this for a calculated column in your table:

    Visit counter =
CALCULATE (
    DISTINCTCOUNT ( Table1[Date] ),
    ALLEXCEPT ( Table1, Table1[Shop] ),
    Table1[Date] <= EARLIER ( Table1[Date] )
)

     

1 Reply

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi Anonymous 

    Try this for a calculated column in your table:

    Visit counter =
CALCULATE (
    DISTINCTCOUNT ( Table1[Date] ),
    ALLEXCEPT ( Table1, Table1[Shop] ),
    Table1[Date] <= EARLIER ( Table1[Date] )
)