You have an API that returns more than 100 columns. The following is a sample of column names.
* client_notified_timestamp
* client_notified_source
* client_notified_sourceid
* client_notified_value
* client_responded_timestamp
* client_responded_source
* client_responded_sourceid
* client_responded_value
You plan to include only a subset of the returned columns.
You need to remove any columns that have a suffix of sourceid.
How should you complete the Power Query M code? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation
Box 1: Table.RemoveColumns
When you do "Remove Columns" Power Query uses the Table.RemoveColumns function Box 2: List.Select Get a list of columns.
Box 3: Text.EndsWith

Comment: *

Name: *

Email: *

Verification: *

You have the line chart shown in the exhibit. (Click the Exhibit tab.)

You need to modify the chart to meet the following requirements:
* Identify months that have order counts above the mean.
* Display the mean monthly order count.
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.

Correct Answer:

Explanation:
Step 1: Create a 12-month...
You can use calculated measure to get the expected result.
1. Create a calculated column for the date.
2. Create a measure for 12 months moving average.
3. Drag the Line Chart into your canvas as below. (step 2 below)

Step 2: Select the line chart
Step 3: From the Analytics pane, add a Median line
Reference:
https://community.powerbi.com/t5/Desktop/Moving-Average/td-p/43041

Comment: *

Name: *

Email: *

Verification: *

You have a report that includes a card visualization.
You need to apply the following conditional formatting to the card while minimizing design effort.
For values that are greater than or equal to 100, the font of the data label must be dark red.
For values that are less than 100, the font of the data label must be dark gray.
Which type of format should you use?

• A.Color scale
• B.Rules
• C.Field value

Comment: *

Name: *

Email: *

Verification: *

You publish a report to a workspace named Customer Services. The report identifies customers that have potential data quality issues that must be investigated by the customer services department of your company.
You need to ensure that customer service managers can create task lists in Microsoft Excel based on the data.
Which report setting should you configure?

• A.Don't allow end user to save filters on this report.
• B.Change default visual interaction from cross highlighting to cross filtering.
• C.Enable the updated filter pane, and show filters in the visual header for this report.
• D.Allow users to add comments to this report.
• E.Choose the type of data you allow your end users to export.

Comment: *

Name: *

Email: *

Verification: *

Which two types of visualizations can be used in the balance sheet reports to meet the reporting goals?
Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.a line chart that shows balances by quarter filtered to account categories that are long-term liabilities.
• B.a clustered column chart that shows balances by date (x-axis) and account category (legend) without filters.
• C.a clustered column chart that shows balances by quarter filtered to account categories that are long- term liabilities.
• D.a pie chart that shows balances by account category without filters.
• E.a ribbon chart that shows balances by quarter and accounts in the legend.

Comment: *

Name: *

Email: *

Verification: *