Volumes with Time Period Control

[Enrico501]

Hi All,

Please Note: I have created a calendar table with Date, Month, Year, Week, Etc.

What I needto do is Adapt this DAX formula to include the ability to Set the Time period I want it to Calculate. 

The formula below Calculates Volumes by a Set criteria, in this case the number of time a Client appears in a Feed list. 

However it calculates this by all the data in the main table which is a 3 month feed. 

How do I adjust this so It will calculate the Number of time the Client appears but by a set time period I can control, eg a 1 Week, 2 Weeks, 1 Month Etc rather than the entire 3 month period. 

"Client Volumes =

CALCULATE(SUM(production[Total Accepted]),FILTER(ALLSELECTED(production),EARLIER(production[client_name])=production[client_name]))"

Thanks in Advance

[Gokul_G16]

Hi @Enrico501 ,

Cool ji, Can please try the bewlow formula for as per understand.

if u want the client how many have been repeated right?.

Step 1 :
take a new column using concatenate
Measure1 =concatenate ( Client name , Month)
step 2 :
=countrows(table name, filter(table name, earlier (Measure1 = measure1))),
If i meaniful you , please review kudo me :),
Regards,
Gokul.