Forum Discussion

Enrico501's avatar
Enrico501
Frequent Visitor
3 years ago

Volumes with Time Period Control

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

 

Need Help

1 Reply

  • Gokul_G16's avatar
    Gokul_G16
    Resolver I
    3 years ago

    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.