Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Summarize two columns into one

Hi all,   I need to combine two columns into one column, and at the same time, sum their values up.    This is a bit weird, cant really find a solution online. Please let me know if I can clarify...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous

     

    You can use this calculated column

     

    Column =
CALCULATE (
    SUM ( Table1[Fee_XXX] ) + SUM ( Table1[Fee_YYY] ),
    ALLEXCEPT ( Table1, Table1[User] )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

Anonymous

 

You can use this calculated column

 

Column =
CALCULATE (
    SUM ( Table1[Fee_XXX] ) + SUM ( Table1[Fee_YYY] ),
    ALLEXCEPT ( Table1, Table1[User] )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks a lot Zubair, great solution