Forum Discussion

icturion's avatar
icturion
Icon for Resolver II rankResolver II
7 years ago
Solved

if statement mutliply values

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

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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