اضغط هنا للانضمام الى قروب فوجي للإختبارات على تيليقرام

اختبار شهادة مايكروسوفت Microsoft Power BI Data Analyst

السؤال 20 من 50

كل الأسئلة

You have a Power BI semantic model named Model1 that contains a single table named Sales.

Sales contains the following columns:

Customer_Name (Text)
Sale_Date (Date)
Sales_Amount (Decimal)

You need to provide users with the ability to select a customer and limit the data in Model1 to only that customer. The solution must meet the following requirements:

The customer selection must affect all the reports that connect to Model1.
All valid customer names in the sales data must be available for the users to choose.
Model1 will be refreshed on an ad-hoc basis and must display the most recent sales data after each refresh is complete.

Which three actions should you perform in sequence?

الخيارات

  • A Create a query that outputs a list of unique customer names.
  • B Create a parameter that uses a list of unique customer names as an input query.
  • C In the query, apply a text filter to the Customer_Name column and make the filter equal to the value of the parameter.

النقاشات

لا توجد نقاشات منشورة لهذا السؤال حالياً.