You have a Power BI data model that contains a table named Employees. The table has the following columns:
* Employee Name
* Email Address
* Start Date
* Job Title
You are implementing dynamic row-level security (RLS).
You need to create a table filter to meet the following requirements:
* Users must see only their own employee data
* The DAX expression must work in both Power 81 Desktop and the Power BI service.
Which expression should you use?
You view a query named Transactions as shown in the following exhibit.
The query gets CSV files from a folder.
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.
You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:
* Customer ID
* Customer Name
* Phone
* Email Address
* Address ID
Address contains the following columns:
* Address ID
* Address Line 1
* Address Line 2
* City
* State/Region
* Country
* Postal Code
The Customer ID and Address ID columns represent unique rows.
You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.
What should you do?
You need to create the Top Customers report.
Which type of filter should you use, and at which level should you apply the filter? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit.
You plan to develop a Power BI model as shown in the Power BI Model exhibit.
You plan to use Power BI to import data from 2013 to 2015.
Product Subcategory [Subcategory] contains NULL values.
End of repeated scenario.
You implement the Power BI model.
You add another table named Territory to the model. A sample of the data is shown in the following table.
You need to create a relationship between the Territory table and the Sales table.
Which function should you use in the query for Territory before you create the relationship?
