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

[Irwin]

Hi,

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. 

Ie:

Date                   Item              Value

01-01-2019        Books                   8

01-01-2019        Shoes                  88

etc...

Preferably I would like to do this in the query editor.

Any help would be appreciated. Thank you very much.

KR

[Irwin]

Dude! Thank you. You are a genius. Much appreciated 🙂

[nvprasad · Accepted solution]

Hi,

You can achieve this using "Group By" transformation (Check in Trasnform tab).

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad