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

السؤال 22 من 50

كل الأسئلة

You have data in a Microsoft Excel worksheet as shown in the following table.

You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:

If the discount column returns an error, a discount of 0.05 must be used.
All the rows of data must be maintained.
Administrative effort must be minimized.

What should you do in Power Query Editor?

الخيارات

  • A Select Remove Errors.
  • B Edit the query in the Query Errors group.
  • C select Replace Errors.
  • D Select Keep Errors.

النقاشات

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