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

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