ACCURACY PAST 2 WEEKS

[Anonymous]

ACCURACY PAST 2 WEEKS = CALCULATE(Cycle_Count_Accuracy_Report[ACCURACY],FILTER('DATE',DATESBETWEEN('DATE'[Date],TODAY(),TODAY()-14)))

FOrmula is not generating

[v-frfei-msft]

Hi @Anonymous ,

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

Regards,
Frank

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

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