Forum Discussion
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 more. Thank you.
Anonymous
You can use this calculated column
Column = CALCULATE ( SUM ( Table1[Fee_XXX] ) + SUM ( Table1[Fee_YYY] ), ALLEXCEPT ( Table1, Table1[User] ) )
2 Replies
- Zubair_Muhammad
Community Champion
Anonymous
You can use this calculated column
Column = CALCULATE ( SUM ( Table1[Fee_XXX] ) + SUM ( Table1[Fee_YYY] ), ALLEXCEPT ( Table1, Table1[User] ) )