Count of Repeat Visitors on each date

[nagaraj007]

Hello All,

I need to know the count of repeated visitors based on URN2 day on day.

For ex: 26 September 2019 - 2 Repeated Visitors

            27 September 2019 - 5 Repeated Visitors

Please advise how to get this result

[Anonymous · Accepted solution]

hi @nagaraj007 

Create new Calculated Column by using this formula

Count = CALCULATE(COUNTA('Table'[Name]), FILTER('Table','Table '[date]= EARLIER('Table'[date])))

regards,

naveen