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

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