Table with sum of values based on distinct values in other table

[flo99]

Dear PBI Community,

I have a table with 4 columns: revenue, reference, year and month. The table looks like this:

Now I need a new table with the sum of the revenue if the the reference is the same. It should look like this:

Is that possible?

I hope for your assistance. Many thanks in advance.
Flo

[amitchandak]

@flo99 , if you put it in visual and take sum of revenue it should work. Keep others un summarized

Or Create a new table

New Table =summarize(Table, Table[Reference], Table[Year], Table[Month], "Revenue", sum(Table[Revenue]))

[flo99]

It worked with the new table. Thanks a lot amitchandak!