Forum Discussion

Joak's avatar
Joak
Frequent Visitor
9 years ago
Solved

Summarize issue

Hello,    In a new table, I want to summarize a column; and then sum the values that are matching together :    ExistingTable-   Column A              Values A                                2...
Need Help
Show and Tell
Tips and Tricks
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    Joak,

     

    You may use GROUPBY Function as well. By the way, to help close this thread, accept the solution above. Your contribution is highly appreciated.

    New table =
GROUPBY (
    ExistingTable,
    ExistingTable[Column A],
    "Values", SUMX ( CURRENTGROUP (), ExistingTable[Values] )
)
Joak's avatar
Joak
Frequent Visitor
9 years ago

Thanks, you're right it works now thanks for the highlight and the article ! 

 

 

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
9 years ago

Joak,

 

You may use GROUPBY Function as well. By the way, to help close this thread, accept the solution above. Your contribution is highly appreciated.

New table =
GROUPBY (
    ExistingTable,
    ExistingTable[Column A],
    "Values", SUMX ( CURRENTGROUP (), ExistingTable[Values] )
)