if statement mutliply values

[icturion]

Hello power bi community,

We have price agreements for various customers. Now the intention is to multiply a value by a certain value depending on a customer.

Example, for customers A, B and C, multiply sell by 2.1. For customer D, multiply by 1.8. customer E multipy by 1.5. and for all other customers multiply by 2.5.

Thank you for your help

ICTURION

[Anonymous · Accepted solution]

Hi @icturion ,

Try this New caculated column with this formula:

Total1 = 
if(
    'Table (4)'[Customer]="A"|| 'Table (4)'[Customer]="B"||'Table (4)'[Customer]="C",'Table (4)'[Numbers]*2.1,
If(
    'Table (4)'[Customer]="D",'Table (4)'[Numbers]*1.8,
If(
    'Table (4)'[Customer]="E",'Table (4)'[Numbers]*1.5,
'Table (4)'[Numbers]*2.5
)
)
)

My output based on your sample:

Let me know if this is what you are looking for.

Thanks,

Tejaswi

[icturion]

thank you