Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Multiply in different conditional

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...
Need Help
  • jennratten's avatar
    jennratten
    5 years ago

    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)
jennratten's avatar
jennratten
Icon for Super User rankSuper User
5 years ago

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)