Multiply in different conditional

[Anonymous]

I have a big data below is just a sample:

Status | Annual Amount | Paid Amount | Exchange rate | Factor | Total
A        | 2400                   | 2000              | 7.8                   | 12       | Annual Amount x Exhchange rate x Factor
B        | 3270                   | 620                | 7.8                   | 12       | Paid Amount x Exhchange rate x Factor

How to write a formaul when Status =A or B then Total = above formula, the result need to show in the same column. Thank you!!!

[jennratten · Accepted solution]

Here you are...

= Table.AddColumn(Source, "Total", each if [Status] = "A" then [Annual Amount] * [Exchange Rate] * [Factor] else [Annual Amount] * [Exchange Rate] * [Factor], Currency.Type)