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

INVENTORY aCCURACY FOR LAST 14 DAYS

I am attempting to generate an Inventory Accuracy Percentage but is getting a Syntax Error Message.

 

WEEK ACCURACY = CALCULATE(COUNTROWS(Cycle_Count_Accuracy_Report[ADDDATE]Cycle_Count_Accuracy_Report[VARIANCES]="NOVARIANCE"),COUNTROWS(Cycle_Count_Accuracy_Report),0),FILTER('DATE',DATESBETWEEN('DATE'[Date],TODAY(),TODAY()-14)))
 
This the formula i am attempting to use.
4 REPLIES 4
aadams13 Frequent Visitor
Frequent Visitor

Inventory Accuracy Formula

I am attempting to generate an Inventory Accuracy Percentage but is getting a Syntax Error Message.

 

WEEK ACCURACY = CALCULATE(COUNTROWS(Cycle_Count_Accuracy_Report[ADDDATE]Cycle_Count_Accuracy_Report[VARIANCES]="NOVARIANCE"),COUNTROWS(Cycle_Count_Accuracy_Report),0),FILTER('DATE',DATESBETWEEN('DATE'[Date],TODAY(),TODAY()-14)))
 
This the formula i am attempting to use.
Highlighted
Community Support Team
Community Support Team

Re: Inventory Accuracy Formula

Hi @aadams13 ,

 

AFAIK, count rows not contains any optional parameter allow you to add filters. If you wanted to count the filtered table rows, please package then with filter function first.

 

Sample:

WEEK ACCURACY =
CALCULATE (
    COUNTROWS (
        FILTER (
            ALLSELECTED ( Cycle_Count_Accuracy_Report ),
            Cycle_Count_Accuracy_Report[VARIANCES] = "NOVARIANCE"
        )
    ),
    FILTER ( 'DATE', DATESBETWEEN ( 'DATE'[Date], TODAY (), TODAY () - 14 ) )
)

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
aadams13 Frequent Visitor
Frequent Visitor

Re: Inventory Accuracy Formula

It is still not wokring for me

Community Support Team
Community Support Team

Re: Inventory Accuracy Formula

HI @aadams13 ,

 

Please share more details informations to help us clarify your scenario.

How to Get Your Question Answered Quickly

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)