- All Exams Instant Download
Which DAX expression should you use to get the ending balances in the balance sheet reports?
Which DAX expression should you use to get the ending balances in the balance sheet reports?A . CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), DATESQTD( 'Date'[Date] ) )B . CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), LASTDATE( 'Date'[Date] ) )C . FIRSTNONBLANK ( 'Date' [Date] SUM( BalanceSheet[BalanceAmount] ) )D . CALCULATE (...
Which type of visualization should you use?
You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success . Which type of visualization should you use?A . Key influencesB . Funnel chartC . Q&AD . Line and...
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...
