IF else statement with multiple condition

[Anonymous]

Hi Good Morning,

I have a formula from excel that I can't seem to find a way to put in my formula in power BI. Sorry not really sure on how power BI works till now. 
here's the formula : = =SUM(AH2:AK2,AN2)+IF(AF2="O",AO2,0). Anyone can help to solve this pls?

here's the table:

=SUM(AH2:AK2,AN2)+IF(AF2="O",AO2,0)

[HotChilli · Accepted solution]

In Power Query, add a custom column. 

[AH] + [AI] +   any other columns     + (if [AF2] = "O" then [AO2] else 0)

Make sure that the columns have the correct datatypes