cancel
Showing results for
Did you mean:
Frequent Visitor

## More complicated Repeat Customer Pattern

I'll give an example of what I'm trying to acheive, with some background:

The data I pull is from 1/1/19 to current day.

I'd like to see our repeat/return customers each month. I plan to display these in a monthly line graph and potentially a daily line graph using order_date as the x axis.

Example: When I click on January 19 in the graph, someone can qualify to be a repeat customer if she ordered a service on the 19th and on the 1st. When I click on the graph on January 1 in the graph, she should not appear--she had only booked one job at that point in time, so she was not a repeat customer at that time.

Does anyone know how to do this, or can point me in a good direction? I've only been using BI for 3 months.

1 ACCEPTED SOLUTION

Accepted Solutions
Regular Visitor

## Re: More complicated Repeat Customer Pattern

If you have a data model that looks similar to this:

Then you can get the following output:

Using this type of calculation:

```Repeat Customer Count =
CALCULATE (
COUNTROWS ( 'Customer' ),
FILTER (
'Customer',
CALCULATE (
COUNTROWS ( VALUES ( 'Data'[Date] ) ),
FILTER ( ALL ( 'Date'), 'Date'[Date] <= MAX ( 'Date'[Date] ) )
) > 1
&& CALCULATE(COUNTROWS('Data')) >= 1
)
)```

I have uploaded a sample workbook here: Sample Workbook

2 REPLIES 2
Regular Visitor

## Re: More complicated Repeat Customer Pattern

If you have a data model that looks similar to this:

Then you can get the following output:

Using this type of calculation:

```Repeat Customer Count =
CALCULATE (
COUNTROWS ( 'Customer' ),
FILTER (
'Customer',
CALCULATE (
COUNTROWS ( VALUES ( 'Data'[Date] ) ),
FILTER ( ALL ( 'Date'), 'Date'[Date] <= MAX ( 'Date'[Date] ) )
) > 1
&& CALCULATE(COUNTROWS('Data')) >= 1
)
)```

I have uploaded a sample workbook here: Sample Workbook

Highlighted
Frequent Visitor

## Re: More complicated Repeat Customer Pattern

Thank you for your solution--it worked!

Announcements

Kudos to you if you earned one of these! Check your inbox for a notification.

#### Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

#### Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,368)