Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create a new table that groups values from an existing table?

I have a sales table and want to create a new table that groups the sales table by salesman and customer, summing sales_ammount.  
I know how to do this in SQL, but I want to do it in PowerBI since my dashboard uses filters on the sales table.  
To clarify, my sales table is like this:

SalesIDSalesmanCustomerSalesAmmount
1AdamZach50
2AdamZach10
3BillZach500
4BillYael900

And I want a new Salesman and Customer ammounts to look like this:

SalesmanCustomerTotal_Sales_From_Salesman_to_Customer
AdamZach60
BillZach500
BillYael900

 

How could I accomplish this in powerBI? I have been trying to use DAX to define a new table (specifically the "Table.Group" function but I can't get it to work.  Thanks! 

3 Replies