Which DAX expression should you use to get the ending balances in the balance sheet reports?
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.
You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?
You have the Performance analyzer results shown in the following exhibit.
You have a Power B1 report that contains a bar chart. The bar chart displays sales by country. You need to ensure that a summary of the data shown on the bar chart is accessible by using a screen reader. What should you configure on the bar chart?
You have a Power Bi model mat contains a table named Date. The Date table contains the fallowing columns:
• Date
• Fiscal year
• Fiscal Quartet
• Month Name
• Calendar Year
• Week Number
• Month Number
• Calendar Quarter
You need to create a calculated table based on the Date table. The calculated tab*e must contain only unique combinations of values for Calendar Year. Calendar Quarter and Calendar Month. Which DAX function should you include in the table deflation?
You plan to embed multiple visualization in a public website.
Your Power BI infrastructure contains the visualizations configured as shown in the following table.
Which two visualizations can you embed into the website? Each correct answer presents a complete the solution.
NOTE: Each correct selection is worth one point.
You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions.
You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.
What should you recommend?
You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server.
You need to ensure that all the visualization in the report can be consumed by users.
Which two types of visualizations should you exclude from the report? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You use Power Query Editor to preview the data shown in the following exhibit
You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative 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.
