Hello All, Aggressively learning Power BI and doing a project at the same time. But I am stuck on a logic. Please help. I want to Subtract two columns based on the Product category. I want to achieve the below result set. Here is the logic I am looking for IF Category = Red then (Amount_One) - (Amount_Two) else if Category = Black then (Amount_One) - (Amount_Three) ProductCategoryAmount_OneAmount_TwoAmount_ThreeIF Category = Red then (Amount_One) - (Amount_Two) else if Category = Black then (Amount_One) - (Amount_Three)ARed100109090ARed2002080180ARed3003070270ARed4004060360ARed5005050450ARed6006040540BBlack7007030670BBlack8008020780BBlack9009010890BBlack100010001000BBlack1100110-101110BBlack1200120-201220Thanks,Vidya

Forum Discussion

Helper II

6 years ago

Solved

Hello All,

Aggressively learning Power BI and doing a project at the same time. But I am stuck on a logic. Please help.

I want to Subtract two columns based on the Product category. I want to achieve the below result set.

Here is the logic I am looking for
IF Category = Red then (Amount_One) - (Amount_Two) else if Category = Black then (Amount_One) - (Amount_Three)

Product	Category	Amount_One	Amount_Two	Amount_Three	IF Category = Red then (Amount_One) - (Amount_Two) else if Category = Black then (Amount_One) - (Amount_Three)
A	Red	100	10	90	90
A	Red	200	20	80	180
A	Red	300	30	70	270
A	Red	400	40	60	360
A	Red	500	50	50	450
A	Red	600	60	40	540
B	Black	700	70	30	670
B	Black	800	80	20	780
B	Black	900	90	10	890
B	Black	1000	100	0	1000
B	Black	1100	110	-10	1110
B	Black	1200	120	-20	1220

Thanks,

Vidya

Anonymous

IF(Table1[Category] = “Red”, [Amount_One]-[Amount_Two], [Amount_One]-[Amount_Three]]

Best,
Paul