Question 271

You have a Power BI report.
You need to create a calculated table to return the 100 highest spending customers.
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 272

You have a table that contains a column named Phone. The following is a sample of the data in the Phone column.

You need to add a new column that contains the data in the format of nnn-nnn-nnnn.
How should you complete the Query Editor formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 273

You use Power Bi Desktop to create a Power Bl data model and a blank report You need to add the Word Cloud visual shown in the following exhibit to the report.

The solution must minimize development effort
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 274

You have a Power B1 report that contains the visuals shown in the following table.

You need to modify the location of each visual.
What should you modify for each visual?
  • Question 275

    The table has the following columns.

    You need to add a column that will be used to sort the Year Month column chronologically.