Counter by date

[Anonymous]

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...

Date	Shop	Visit counter
27/03/2019	Shop 1	1
27/03/2019	Shop 2	1
27/03/2019	Shop 1	1
27/03/2019	Shop 3	1
27/03/2019	Shop 1	1
28/03/2019	Shop 1	2
29/03/2019	Shop 1	3
30/03/2019	Shop 1	4
30/03/2019	Shop 2	2
30/03/2019	Shop 3	2

Thank you!

[AlB · Accepted solution]

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] )
)