Add Group By Column

[Anonymous]

Producer	region	run	material	cost	total	total group
abc	mars	fast	a	5	5	15
abc	mars	fast	b	10	10	15
abc	mars	slow	c	15	15	35
abc	mars	slow	d	20	20	35
xyz	neptune	fast	e	5	5	30
xyz	neptune	fast	f	10	10	30
xyz	neptune	fast	g	15	15	30

Hi guys I looking for DAX that will add a new column "total group" to table as shown above. the last column

The column should group the values by producer, region and run and it should NOT groupby the material column.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Column = CALCULATE(SUM('Table'[total]),ALLEXCEPT('Table','Table'[Producer],'Table'[region],'Table'[run]))

Best Regards,

Jay

[Anonymous]

Hi,

Please refer to this documentation and see if it solves your issue. 
In regards to creating the additional column, do you want to concatenate the values or have a numeric column?
Concatenate: Column D = [Producer]  & [region]  & [run]

[Anonymous]

It will be numeric and not concatenate.

[Anonymous]

https://docs.microsoft.com/en-us/power-query/group-by

[Anonymous]

I am looking for DAX as the group by in power query is taking lot of time to process.