You 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?
A. Remove the rows from Lineitems where LineItems[invoice Date] is before the beginning of last month
B. Merge Suppliers and Uneltems.
C. Group Lineltems by Lineitems[ invoice id) and Lineitems[invoice Date) with a sum of Lineitems(price).
D. Remove the Lineitems[Description] column.
