cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
snifer Member
Member

sum of row with unique id

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 

1 REPLY 1
Super User
Super User

Re: sum of row with unique id

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

 

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)