Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Add Group By Column

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 x...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

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

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
Anonymous
Not applicable
3 years ago

It will be numeric and not concatenate.