You are enhancing a Power BI model that has DAX calculations.
You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.
Which DAX functions should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://www.kasperonbi.com/get-the-ytd-of-the-same-period-last-year/

Comment: *

Name: *

Email: *

Verification: *

You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table. Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation
A DAX calculated column
Data.EndOfQuater(#data([Year), [Month], 1))

Comment: *

Name: *

Email: *

Verification: *

You have a table that contains the following three columns:
City
Total Sales
Occupation
You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)

How should you configure the visualization? 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/power-bi/visuals/power-bi-visualization-influencers

Comment: *

Name: *

Email: *

Verification: *

You are developing a sales report that will have multiple pages. Each page will answer a different business question.
You plan to have a menu page that will show all the business questions.
You need to ensure that users can click each business question and be directed to the page where the question is answered. The solution must ensure that the menu page will work when deployed to any workspace.
What should you include on the menu page?

• A.Create a text box for each business question and insert a link.
• B.Create a button for each business question and set the action type to Bookmark.
• C.Create a Power Apps visual that contains a drop-down list. The drop-down list will contain the business

Comment: *

Name: *

Email: *

Verification: *

You have a report page that contains the visuals 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.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-interactions

Comment: *

Name: *

Email: *

Verification: *