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.
Go to Solution.
You can use this calculated column
SUM ( Table1[Fee_XXX] ) + SUM ( Table1[Fee_YYY] ),
ALLEXCEPT ( Table1, Table1[User] )
Thanks a lot Zubair, great solution