Sum repeat orders by week, and still be able to date slice down/up

[Anon29]

Hi, I am wanting to show how many repeat orders we get by date, week, month and year.
Criteria for a repeat order is total orders per customer minus their initial order of the week. The formula I am currently using for weekly repeat orders (not sure if this is the best option though):

Repeat orders =
SUMX(
SUMMARIZE(
'Order Table',
'Order Table'[Customer],
'Date Table'[Week]),
[Total Orders] - 1)

I have a date slicer and I want visuals to show total repeat orders per Date, per week day (Mon, Tues etc), per month, and per year, while keeping the same criteria for a repeat order.

I can't seem to make the visuals show the correct weekly repeat orders if I select any date aside from weekly, so any help would be greatly appreciated.

My data is on a daily basis, and looks something like this weekly:

Week	Total Customers	Total orders	Repeat orders
Week 4	238	266	28
Week 5	163	173	10
Week 6	177	189	12
Week 7	70	75	5

[amitchandak]

@Anon29 , I have used an approach here for repeat, the duration you can change based on the need

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...
Customer Retention Part 2: Period over Period Retention:https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retenti...

[Anon29]

Hi @amitchandak , thank you for the links. I am still fairly new to Dax and looking through the codes, I am struggling to adapt it to what I am needing it to do. I want to identify my clients first order of the week, then count all the following repeat rows from that client (so the clients 2nd order onwards) till the end of the week. My goal is to be able to show repeat orders down to the daily level,  and up to the yearly level too.

What makes it bit tricker is that I have 3 main customer groups, (retailers, client and suppliers) so with the above, I am hoping to be able to show that the customer called 10 times this week, 5 repeat times to our client team, and 3 repeat times to our retail team, when slicing it by customer groups.