cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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?

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?

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
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

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

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 293 members 2,991 guests
Please welcome our newest community members: