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 ...
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

     

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

 

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

thank you