cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aadams13 Frequent Visitor
Frequent Visitor

ACCURACY PAST 2 WEEKS

ACCURACY PAST 2 WEEKS = CALCULATE(Cycle_Count_Accuracy_Report[ACCURACY],FILTER('DATE',DATESBETWEEN('DATE'[Date],TODAY(),TODAY()-14)))
 
FOrmula is not generating
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: ACCURACY PAST 2 WEEKS

Hi @aadams13 ,

 

Please update your formula as below, as the today()-14 should be the start date.

 

Measure = CALCULATE(SUM(Table1[value]),DATESBETWEEN(Table1[date],TODAY()-14,TODAY()))

 

Reagrds,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: ACCURACY PAST 2 WEEKS

Hi @aadams13 ,

 

Please update your formula as below, as the today()-14 should be the start date.

 

Measure = CALCULATE(SUM(Table1[value]),DATESBETWEEN(Table1[date],TODAY()-14,TODAY()))

 

Reagrds,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: ACCURACY PAST 2 WEEKS

Hi @aadams13 ,

 

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.


Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.