Create new table based on distinct column from another table

[Anonymous]

Hello,

My table follows this structure:

Name	CODE	Date	Lab
John	WWW	09/04/2021	1
John	WWW	09/04/2021	1
John	WWW	09/04/2021	1
Lisa	ZZZ	11/09/2021	9
Lisa	ZZZ	11/09/2021	9
Eric	QQQ	01/01/2021	5
Kimber	DDD	12/12/2021	8
Kimber	DDD	12/12/2021	8

I would like to create a calculated table that shows all columns from the original table, but only distinct rows based on the CODE column.

My expected result would be a new table like this:

Name	CODE	Date	Lab
John	WWW	09/04/2021	1
Lisa	ZZZ	11/09/2021	9
Eric	QQQ	01/01/2021	5
Kimber	DDD	12/12/2021	8

Can someone help me?

[Anonymous · Accepted solution]

New Table >

Newtable = SUMMARIZE('Table1','Table1'[Name],'Table1'[CODE   ],'Table1'[Date],'Table1'[Lab])

[Anonymous]

That was exactly it! Thanks 🙂