How to create a new table based on another table?

Question

Hi Expert,&nbsp;I have a data set which is the list of employees, their department and slary. The table looks like below:Employee IDDepartmentSalaryAHR100BHR200CIT100DMarketing300EMarketing400FAdmin300GAdmin400HAdmin200&nbsp;I wan to create a new table (not the visualization in the canva) which summaries the headcount, total labor cost and average labor cost of each department.&nbsp;DepartmentTotal Labor CostHeadcountAv. Labor Cost (Total Labor Cost/Headcount)HR3002150IT1001100Marketing7002350Admin9003300&nbsp;Is it possible to use the DAX to achieve that?Many thanks!Best regards,Tom

pattemmanohar · Accepted Answer

TomLU123&nbsp;Please create a New Table as below
&nbsp;
Test270Out = SUMMARIZE(Test270Summarize,Test270Summarize[Department],"TotalLabourCost",SUM(Test270Summarize[Salary]),"HeadCount",COUNT(Test270Summarize[Employee ID]),"AvgLabourCost",AVERAGE(Test270Summarize[Salary]))

Forum Discussion

How to create a new table based on another table?

1 Reply

Related content

Create new table

Lakehouse Table Generate Create Table

Column created in a table appears in another table

Create table from another table with conditions

Create rows from 2 tables

Employee ID	Department	Salary
A	HR	100
B	HR	200
C	IT	100
D	Marketing	300
E	Marketing	400
F	Admin	300
G	Admin	400
H	Admin	200

Department	Total Labor Cost	Headcount	Av. Labor Cost (Total Labor Cost/Headcount)
HR	300	2	150
IT	100	1	100
Marketing	700	2	350
Admin	900	3	300