Sum Table Values To New Table With Unique ID

[nj-matt]

I have a dataset that needs some minor cleansing and then need to be reduced to a new table with unique values.

I created a "Grouped Month" to aggregate prior month values to the current month.

Customer	Product	ID	Month	Grouped Month	Sales
Globex	Candy	Globex-Candy	Sep	Dec	100
Globex	Candy	Globex-Candy	Nov	Dec	50
Globex	Candy	Globex-Candy	Dec	Dec	75

The issue is that I need the ID to be unique so that I can link to another table with multiple values.

This is what I need -->

ID	Grouped Month	Sales
Globex-Candy	Dec	225

I tried creating a new table with the summarize formula but I am doing something wrong...

[az38 · Accepted solution]

Hi @nj-matt 

try new table

Table = SUMMARIZE(
'Table 1';'Table 1'[ID];'Table 1'[Groued Month];
"Sales"; SUM('Table 1'[Sales])
)

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn