sum of row with unique id

[snifer]

I want to create a table based on the id in a different table

with this condition :

if it is single row with  unique id i want to copy paste the amount how it is,

if there are multiple rows with unique id I want to create one row with the sum of amont and the unique id

then I want to add columns from the same table where are the id 

[TomMartens]

Hey,

not sure what kind of table you need:

DAX: 

You can use
ADDCOLIMNS(
    SUMMARIZE(
    ...
    )

   ,"columnname1", expression
)

PowerQuery

• create a new table
• use GroupBy
• use merge to get the values (MIN MAX ...)

Maybe you should consider to create sample data, upload the datafile to onedrive or dropbox and share the link

Regards

Tom