How can I convert this Excel Formula to a Column calculation in Power BI?

Hi vanonyuo 

use the following formula:

Final FA =
IF(
	(('Table1'[AnnualPay]/12) * 2 + 'Table1'[Final_A_Amount] + 'Table1'[Discretionary_Award]) < 137700,
	('Table1'[Final_AIP_Amount] + 'Table1'[Discretionary_Award]) * 0.0765,
	('Table1'[Final_AIP_Amount] + 'Table1'[Discretionary_Award]) * 0.0145
)

Regards FrankAT

FrankAT 

Thank you for you swift response. Discretionary is in a different table 2 and I can only use RELATED to add. So I

So I amended a bit and It worked!!!

Final FA =
IF(
('Table1'[AnnualPay]/12) * 2 + 'Table1'[Final_A_Amount] + RELATED('Table1'[Discretionary_Award]) < 137700,
('Table1'[Final_AIP_Amount] + RELATED('Table1'[Discretionary_Award])) * 0.0765,
('Table1'[Final_AIP_Amount] + RELATED('Table1'[Discretionary_Award])) * 0.0145
)

Thank you So Much!