Summarize two columns into one

[jichaowu]

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.

[Zubair_Muhammad · Accepted solution]

@jichaowu

You can use this calculated column

Column =
CALCULATE (
    SUM ( Table1[Fee_XXX] ) + SUM ( Table1[Fee_YYY] ),
    ALLEXCEPT ( Table1, Table1[User] )
)

[jichaowu]

Thanks a lot Zubair, great solution