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...   Date Shop Visit counter 2...
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] )
)

     

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