You have a sales system that contains the tables shown in the following table.
The Date table is marked as a date table.
DatelD is the date data type. You need to create an annual sales growth percentage measure.
Which DAX expression should you use?
You are creating a report in Power BI Desktop.
You load a data extract that includes a free text field named coll.
You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model.
What should you do?
You have a Q&A visual that displays information from a table named Carriers as shown in the following exhibit.
You need to ensure that users can ask questions by using the term airline or carrier. The solution must minimize changes to the data model.
What should you do?
You have a BI dataset and a connected report.
You need to ensure that users can analyze data in Microsoft Excel by connecting directly to the dataset.
You grant the users the Build permission for dataset
What Should do next?
You create a Power Bl report1 named Summary1 You discover that Summary1 is slow.
You run Performance analyzer to identify performance metrics for Summary1
Which two metrics display the execution duration in Performance analyzer* Each correct answer present part of the solution. NOTE: Each correct answer is worth one point.
In Power Query Editor, you have a query named Sales Data that contains the following columns.
You need to create two queries named Product Dimension and Sales Fact based on the Sales Data query. The solution must minimize maintenance effort and the site of the semantic model.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE Each correct selection is worth one point.
You have a query in Power Query Editor that contains the following data.
You need to transform the data to appear as shown in the following table.
What should you do?
Each Region value appears only on the tow where it first occurred. Each subsequent occurrence of the Region value is blank.
You need to ensure that every row contains the connect non-blank value The solution must minimize development effort.
Which column should you select, and which action should you perform on the column? To answer, select the appropriate options in the answer area. NOTE; Each connect selection is worth one point.
