Forum Discussion

MaxItaly's avatar
MaxItaly
Icon for Helper III rankHelper III
8 years ago
Solved

Help creating a table based on another one (only distinct value)

Hello everyone, I'm having some problems trying to create a table. Let's say I have a table named "Table1", that has "Client", "Quantity". I may have more rows for the same "Client" with different...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    Hi MaxItaly,

     

    You need to create a new table with the following sintax:

     

    Table2 = SUMMARIZE(Table1,Table1[Client],"Quantit"y, SUM(Table1[Quantity]))

     

    You can also duplicate the table on the query editor and choose transform make a group by client and sum the quantity.

     

     

     


    Regards

    MFelix

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi MaxItaly,

 

You need to create a new table with the following sintax:

 

Table2 = SUMMARIZE(Table1,Table1[Client],"Quantit"y, SUM(Table1[Quantity]))

 

You can also duplicate the table on the query editor and choose transform make a group by client and sum the quantity.

 

 

 


Regards

MFelix