Question 381

You have a Power Bl report that contains a measure named Total Sales.
You need to create a new measure that will return the sum of Total Sates for a year up to a selected date. How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 382

You have data in a Microsoft Excel worksheet as shown in the following table.

You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:
* If the discount column returns an error, a discount of 0.05 must be used.
* All the rows of data must be maintained.
* Administrative effort must be minimized.
What should you do in Power Query Editor?
  • Question 383

    Exhibit:

    You need to create a report that meets the requirements:
    * Visualizes the Sales value over a period of years and months
    * Adds a Slicer for the month
    * Adds a Slicer for the year
    Which three actions Should you perform in sequence?

    Question 384

    You need to grant access to the business unit analysts.
    What should you configure? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 385

    You have a Power BI app named App1. The privacy for the App1 workspace is set to Private.
    A user named User1 reports that App1 does not appear in the My organization AppSource. App1 appears in the My organization AppSource for your account.
    You need to ensure that User sees App1 from the My organization AppSource.
    What should you do?