cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jichaowu Frequent Visitor
Frequent Visitor

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.

 

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Summarize two columns into one

@jichaowu

 

You can use this calculated column

 

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

Re: Summarize two columns into one

@jichaowu

 

You can use this calculated column

 

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

Re: Summarize two columns into one

Thanks a lot Zubair, great solution