IF or SWITCH multiple values not getting syntax right

[BartVlek]

Hi I am struggling with this:

I need a new column in my model where I have the correct suppliers discount. There is a column SUPDISC but there are exceptions. So there are two columns that have an effect on SUPDISC: 1= SUPPLIER 2 = SHOP. Now what I want is something like:

if supplier = COCACOLA and SHOP = AMSTERDAM then the discount should be 65.00,

if supplier = PEPSICOLA and SHOP = ROTTERDAM then the discount should be 60,00,

in all the other occasions the value from SUPDISC must be applied.

Hope somebody can help me. Many thanks in advance

[amitchandak]

@BartVlek , a New column like

Switch ( true(),
[supplier] = "COCACOLA" && [SHOP] = "AMSTERDAM" , 65.00,
[supplier] = "PEPSICOLA" && [SHOP] = "ROTTERDAM" , 60.00,
[SUPDISC]
)

Same can be done with IF

[BartVlek]

Thank you !! And what does it look like when the name of the new column should be SUPDISCDEF?

[amitchandak]

@BartVlek , not sure what you mean by that. A new column like

SUPDISCDEF =

Switch ( true(),
[supplier] = "COCACOLA" && [SHOP] = "AMSTERDAM" , 65.00,
[supplier] = "PEPSICOLA" && [SHOP] = "ROTTERDAM" , 60.00,
[SUPDISC]
)

[BartVlek]

I transformed your suggestion to the actual situation. The shop doesn't have a name, but a number as you can see.

When I then copy-paste it to PBI-desktop and run, I receive a syntaxis error. What can it be? Do I not need to add the name of the table?

LEVKORTDEF =
SWITCH (
    TRUE (),
    [LEVERANCIER] = "ALDIPRESS"
        && [FIL] = "1", 65.00,
    [LEVERANCIER] = "BETAPRESS"
        && [FIL] = "1", 60.00,
    [LEVKORTING]
)

[Anonymous]

Hi @BartVlek ,

Please try to update the formula of your measure as below to remove double quotation since shop is number type:

LEVKORTDEF =
SWITCH (
    TRUE (),
    [LEVERANCIER] = "ALDIPRESS"
        && [FIL] = 1, 65.00,
    [LEVERANCIER] = "BETAPRESS"
        && [FIL] =1 , 60.00,
    [LEVKORTING]
)

If the above method didn't resolve your problem, please provide the screen shot of syntax error and related formula. Thank you.

Best Regards

Rena

[BartVlek]

Thank you !