- 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 ( MAX (BalanceSheet[BalanceAmount]), LASTDATE (‘Date' [Date]) )View AnswerAnswer:...
What should you do before you can create the relationship?
You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?A . Change the data type of Sales[region_id] to Whole Number.B . In the Sales table, add a measure for sum(sales_amount).C . Change the data type of sales[sales_id] to Text.D...
What should you add to the visual?
You have the visual shown in the Original exhibit. {Click the Original tab.) You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.) What should you add to the visual?A . a measureB . a trendlineC . a forecastD . an Average lineView AnswerAnswer:...
Which relationship should you use to link the tables?
You build a report to analyze customer transactions from a database that contains the tables shown in the following table. You import the tables. Which relationship should you use to link the tables?A . one-to-many from Customer to TransactionB . one-to-one between Customer and TransactionC . one-to-many from Transaction to...
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...
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 calculated column that use a formula of couMTA(Sales[sales_id]>B . a calculated measure that uses a formula of couNTROws(Sales)C . a calculated column that uses a formula of suM(Sales[sales_id])D . a measure that uses a formula...
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 ....
How should you complete the measure?
Topic 2, Contoso Ltd, Case Study Overview This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time...
How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?
You plan to create the chart shown in the following exhibit. How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?A . Create a horizontal line that has a fixed value of 24,000.B . Add a measure to the visual that...
What should you include in the solution?
You need to provide a solution to provide the sales managers with the required access. What should you include in the solution?A . Create a security role that has a table filter on the Sales_Manager table where username = UserName()B . Create a security role that has a table filter...
