Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Group by calculated column

I have the below table, I need to create a calculated column "Overall Product and Trn  Sales",  which will be the sum of SalesAmount for the Trn ID and Product ID summarized. Trn ID Brand Locat...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Create a new column like

    SUMX(filter(Table, table[Trn ID] = earlier (Trn ID)), Table[SalesAmount])

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , Create a new column like

SUMX(filter(Table, table[Trn ID] = earlier (Trn ID)), Table[SalesAmount])