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...
Go to Solution.
Try this for a calculated column in your table:
Visit counter =
DISTINCTCOUNT ( Table1[Date] ),
ALLEXCEPT ( Table1, Table1[Shop] ),
Table1[Date] <= EARLIER ( Table1[Date] )
View solution in original post
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021