cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
S-J Frequent Visitor
Frequent Visitor

Convert a nested if statemtn to DAX

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.

1 ACCEPTED SOLUTION

Accepted Solutions
S-J Frequent Visitor
Frequent Visitor

Re: Convert a nested if statemtn to DAX

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?

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Convert a nested if statemtn to DAX

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 Frequent Visitor
Frequent Visitor

Re: Convert a nested if statemtn to DAX

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?

View solution in original post

Super User
Super User

Re: Convert a nested if statemtn to DAX

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






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





S-J Frequent Visitor
Frequent Visitor

Re: Convert a nested if statemtn to DAX

This worked for me. Thanks. S-J

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 545 members 4,468 guests
Please welcome our newest community members: