Question 225 of 388
Single answerYou have a Power Bi report for the procurement department. The report contains data from the following tables. There is a one-to-many relationship from Suppliers to Lineitems that uses the ID and Supplier ID columns. The report contains the visuals shown in the following table.You need to minimize the size of the dataset without affecting the visuals. What should you do?
ARemove the rows from Lineitems where LineItems[invoice Date] is before the beginning of last monthB.Merge Suppliers and Uneltems.
CGroup Lineltems by Lineitems[ invoice id) and Lineitems[invoice Date) with a sum of Lineitems(price).
✓DRemove the Lineitems[Description] column.
✓
Correct Answer: D
Remove the Lineitems[Description] column.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Microsoft certification topics.