Question 181

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?
  • Question 182

    You need to create a relationship in the dataset for RLS.
    What should you do? To answer select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 183

    You have a Power Bl table named Customer that contains a field named Email Address.
    You discover that multiple records contain the same email address.
    You need to create a calculated column to identify which records have duplicate email addresses.
    How should you complete the OAX expression for the calculated column? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content NOTE: Each correct selection is worth one point.

    Question 184

    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 dat a. The users require insights on the completeness of the data and the value distributions.
    Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

    Question 185

    You have a Power BI imported dataset that contains the data model 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.