You need to create a DAX measure in the data model that only allows users to see projections at the appropriate levels of granularity.
How should you complete the measure? 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.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/dax/isfiltered-function-dax

Comment: *

Name: *

Email: *

Verification: *

You are preparing a financial report in Power BI.
You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.

You need to prepare the data to support the following:
Visualizations that include all measures in the data over time
Year-over-year calculations for all the measures
Which four 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
1. Use first row as header
2. Unpivot all columns other than "Measure"
3. Rename "Attribute" to "Year"
4. Change data type of "Year" to date (Date > Year)

Comment: *

Name: *

Email: *

Verification: *

You need to create a measure that will return the percentage of late orders.
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.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/dax/calculate-function-dax
https://docs.microsoft.com/en-us/dax/filter-function-dax

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: *

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.

Correct Answer:

Explanation
Text Description automatically generated

Box 1: many-to-one
Each employee in the Sales Employees table is assigned to one sales region. Multiple employees can be assigned to each region.
The Suppliers table has a Region column.
Box 2: Suppliers table

Comment: *

Name: *

Email: *

Verification: *