Create a new table from columns from an existing table with unique values

Question

I'm trying to create a new table from an existing table called Samples. The Sample_Id is occuring multiple times in the table, but only a couple of times a value is connected to a sample ID. What I want is to create a table with all sample ID's occuring only once and the sample ID's with a value connected to them should show the value. See an example of the database below:

Sample_Id	Value
13
13
13
24
24	0,76
24
32
32
42
42	0,45
42

The result I want to get is:

Sample_Id	Value
13
24	0,76
32
42	0,45

Can anyone please advise how I can do this? Thanks in advance for your help!

zubair_muhammad · Accepted Answer

Anonymous&nbsp;
&nbsp;
As a calculated table you can use
&nbsp;
Table = SUMMARIZE(Table1,Table1[Sample_Id],"Value",sum(Table1[Value]))

Forum Discussion

Create a new table from columns from an existing table with unique values

2 Replies

Related content

Create columns group

Create a new table from columns from existing tables

Create new column from existing columns

column deleted but column exists

Cannot create liquid clustering on existing unpartitioned table