How to remove a column based on duplicates and summaries values in other columns

Question

Hi,&nbsp;Sorry if the title sounds weird. I tried to make it understandable. I am still a beginner at power bi - sorry if this is a stupid question... 🙂I have the below table:I want to remove "Area" and summaries alle items values so I get a total of books/shoes/icecream on the dates.&nbsp;Ie:Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Item&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Value01-01-2019&nbsp; &nbsp; &nbsp; &nbsp; Books&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;801-01-2019&nbsp; &nbsp; &nbsp; &nbsp; Shoes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 88etc...&nbsp;Preferably I would like to do this in the query editor.&nbsp;Any help would be appreciated. Thank you very much.&nbsp;KR&nbsp;

nvprasad · Accepted Answer

Hi,&nbsp;You can achieve this using "Group By" transformation (Check in Trasnform tab).&nbsp;Appreciate a Kudos! 🙂If this helps and resolves the issue, please mark it as a Solution! 🙂Regards,N V Durga Prasad&nbsp;

Forum Discussion

How to remove a column based on duplicates and summaries values in other columns

2 Replies

Related content

Merge duplicates data in columns

Column count duplicates

Duplicate ranking

Power BI October 2026 Feature Summary

Summary Columns in Matrix