Microsoft PL-300 Question Answer
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?
Microsoft PL-300 Summary
- Vendor: Microsoft
- Product: PL-300
- Update on: Jul 31, 2025
- Questions: 450
