Microsoft PL-300 Question Answer
What should you create to meet the reporting requirements of the sales department?
a measure that uses a formula of SUM (Sales [sales_id])
a calculated column that use a formula of COUNTA(sales [sales_id])
a measure that uses a formula of COUNTROWS (Sales)
a calculated column that uses a formula of SUM (Sales [sales_id])
The sale department requires reports that contain the number of sales transactions.
The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression.
TESTED 17 Jul 2025
Copyright © 2014-2025 ACE4Sure. All Rights Reserved