- All Exams Instant Download
How should you configure the quick measure calculation?
HOTSPOT You are creating a quick measure as shown in the following exhibit. You need to create a monthly rolling average measure for Sales over time. How should you configure the quick measure calculation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth...
What should you recommend?
You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions. You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions. What should you recommend?A . Merge tables by using Power Query.B ....
Which type of visualization should you use?
You have a collection of reports for the HR department of your company. You need to create a visualization for the HR department that shows a historic employee counts and predicts trends during the next six months. Which type of visualization should you use?A . scatter chartB . ribbon chartC...
You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements
HOTSPOT You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements. For each of the following statement, select Yes if the statement is true, Otherwise, select No. NOTE: Each correct...
You have a report page that contains the visuals shown in the following exhibit
HOTSPOT You have a report page that contains the visuals shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: cross-filter...
How should you complete the calculation?
DRAG DROP You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date. The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table. You need to write a calculation that returns the percentage of total...
Which DAX expression should you use?
You need to create a calculated column to display the month based on the reporting requirements . Which DAX expression should you use?A . FORMAT('Date'[date], "MMM YYYY")B . FORMAT('Date' [date], "M YY")C . FORMAT('Date'[date_id], "MMM") ""& & FORMAT('Date'[year], "#")D . FORMAT('Date' [date_id], "MMM YYYY")View AnswerAnswer: A
Which three actions should you perform in sequence?
DRAG DROP You are modeling data in table named SalesDetail by using Microsoft Power Bl. You need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights on the completeness of the data and the value distributions. Which three actions should you...
What should you create to meet the reporting requirements of the sales department?
What should you create to meet the reporting requirements of the sales department?A . a measure that uses a formula of SUM (Sales [sales_id])B . a calculated column that use a formula of COUNTA(sales [sales_id])C . a measure that uses a formula of COUNTROWS (Sales)D . a calculated column that...
How should you create the visualization?
HOTSPOT You need to create a visualization to meet the reporting requirements of the sales managers. How should you create the visualization? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Scenario: The sales managers require a visual...
