Power BI creating a formula in a custom column

[Jkiddin]

I've never worked with Power BI before but i assumed the formulas were similar to Excel but it isn't? I don't know how to create a formula that uses an if statement to calculate a value. What i have right now is: 

IF [Discount] > 0 then value.Multiply([UnitPrice], [Discount]) else 0

but it says the value.multiply is wrong so i don't know if there should be commas or something to separate it since the formula requirements don't pop up as i type. After calculating whether the discount price should be multiplied, i wanted to subtract that price from the value.multiply([UnitPrice], [Quantity]) to get total revenue, but i DON'T know how to even combine these formulas into one long formula like excel does. do i start a new column? a new equal sign underneath? 

[amitchandak]

@Jkiddin , Try like

if [Discount] > 0 then [UnitPrice]* [Discount]  else 0

[Jkiddin]

it still didn't work 😞 

[Fowmy · Accepted solution]

@Jkiddin 

You have typed "IF" with upper case, Power Query is case sensitive, it should be all lower case here. type it as follows:

if [Discount] > 0 then ( [UnitPrice] * [Discount] )  else 0