I am attempting to generate an Inventory Accuracy Percentage but is getting a Syntax Error Message.
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.
WEEK ACCURACY =
ALLSELECTED ( Cycle_Count_Accuracy_Report ),
Cycle_Count_Accuracy_Report[VARIANCES] = "NOVARIANCE"
FILTER ( 'DATE', DATESBETWEEN ( 'DATE'[Date], TODAY (), TODAY () - 14 ) )
It is still not wokring for me
HI @aadams13 ,
Please share more details informations to help us clarify your scenario.
How to Get Your Question Answered Quickly
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!