Forum Discussion
Consolidate by Multiple Criteria
Hello All, I apologize if I have asked too many questions of the community but I think if I could get help with this data set I am working on it would solve most, if not all my problems. Right n...
Hi Anonymous ,
On the query editor you must do the Group by option, then you need to select all the columns that you want to keep like Vendor, Item Number, Po Line and then on the aggregation select Maximum for data and sum for Received quantity on the other columns keep the maximum or minimum since they are equal.
I honestly think that either of these options you both have provided will work!! The only trouble now is trying to get my company to give me access to the Power Query Editor for the table I want to work on. v-lid-msft , MFelix
MFelix
Super User
Super UserHi Anonymous ,
Are you getting the information only on a PBIX file or on the web version?
If yes you can do a table visualization with the maximum and sum on the columns no need to change the query.