Sum of new column created from two separate columns

[mpettigrew]

Hello, I am struggling, and I am new to Power BI.

I want to do something like this:

I have two columns: "Revenue TXN" and "Revenue CAN"

I want to create a new column called "REVENUE MIX" that basically merges these two columns, showing "Revenue TXN" if <> 0, otherwise showing "Revenue CAN"

I want to use this new "REVENUE MIX" column to report totals numbers.

Below is an example of what I'm trying to do in a table:

Invoice Date	Renvenue CAN	Revenue TXN	Revenue Mix
March	200		200
April	100		100
May	65	50	50
June	32.5	25	25
July	400		400
August	390	300	300
September	260	200	200
October	500		500
November	100		100
December	130	100	100
	2177.5	675	1975

Can anyone help!?

Thanks.

[v-lionel-msft]

Hi @mpettigrew ,

Maybe you can do like this:

Revenue Mix = 
IF(
    [Revenue TXN] <> 0,
    [Revenue TXN],
    [Renvenue CAN]
)

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mpettigrew]

The solution suggested did not work.  I'm not sure why. 

However, I have gotten it working now.  I had to create 3 separate measures to have the totals add up correctly:

1) USD TOTAL = CALCULATE ( SUM ( [REVENUE TXN], [CURRENCY] = "USD" )

2) CAN TOTAL = CALCULATE ( SUM ( [REVENUE CAN], [CURRENCY] = "CAN" )

3) REVENUE MIX = [USD TOTAL] + [CAN TOTAL]

Thanks for your help.