Convert a nested if statemtn to DAX

[S-J]

I have a nested IF statement in Excel that works perfectly but I want to recreate it in the Power BI query editor:

=IF(C:C="united kingdom", E2*1.1,IF(C:C="france",E2*1.2,IF(C:C="usa",E2*1.3,"test")))

Please can someone advise the correct syntax.

[Anonymous]

You can use switch / true() combo:

SWITCH(
    TRUE()
    Table[Column] = "united kingdom", [Whatever E2 is ] *1.1,
    Table[Column] = "france", [Whatever E2 is ] *1.2,
    Table[Column] = "usa", [Whatever E2 is ] *1.3,
    "test"
)

[S-J · Accepted solution]

Thanks for your help so far.  Unfortutely I can't get my code to work.

I have tried to create a new column in Power BI that is going to contain my different variants

Syntax below:

Test = SWITCH(TRUE(),BaseData[CountryName] = "United Kingdom", BaseData[SalePrice] *1.1, BaseData[CountryName] = "USA", BaseData[SalePrice] *1.2,"")

I am getting an error saying - Expressions that yield variant data-type cannot be used to define calculated columns.

Can you help?

[parry2k]

@S-J reason it is giving error coz your final condition return text and other return number. you need to change the text to number, may be zero.

[S-J]

This worked for me. Thanks. S-J