Order Frequency, is a customer ordering more than once per week?

[KentuckyCatFan]

Hello,

I am trying to find how many times a customer is ordering weekly (order frequency).  I have a calendar model set up with the below columns:

I need to show order freq by Sold-to & Created on date and figure out if they are ordering more than once/week.   END GOAL: to direct a customer to order only once per week if their multiple orders total a full truck load.

I'm sure I don't need some of the columns I have, but they were my attempt at trying different DAX formulas which didn't work.

I'm really hoping someone has a simple solution.

Thanks for the help.

[amitchandak]

@KentuckyCatFan , First Create a columns and measure like

Have these new columns in Date Table, Week Rank is Important in Date/Week Table

Week Rank = RANKX('Date','Date'[Week Start date],,ASC,Dense)
OR
Week Rank = RANKX('Date','Date'[Year Week],,ASC,Dense) //YYYYWW format

These measures can help
This Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))

Then have a measure like

countx(Values(Cutsomer[Customer]), if([This Week] >1, [Customer], blank()))

[KentuckyCatFan]

@amitchandak:

I'm a bit confused by your comment "First Create a columns and measure like" because it just ends there.  What column & measure should I be creating?  Or, does this first comment refer to what you typed afterwards?

Are you saying I need to create a new table called 'Date' and add the 'week rank' or can I do that within the same table I already have?