Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

If Statement Power BI

Looking for a way to include a If statement with multiple conditions into Power BI. Example 

 

If Column B is 2 numbers greater than Column A  be than investigate. otherwise Do Not Investigate. 

 

example of what I am looking to do.

 

A     B       C

1      3      Investigate

2      2      Do Not Investigate

5      6      Do Not Investigate

7      9      Investigate

8      9      Do Not Investigate

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Below dax can be used as per your example:

    Column =
    IF(
    B > A + 2,
    "Investigate",
    "Do Not Investigate"
    )

     

    You can use nested If statement to have multiple conditions as shown below:

    Price Group =
    IF(
    'Product'[List Price] < 500,
    "Low",
    IF(
    'Product'[List Price] < 1500,
    "Medium",
    "High"
    )
    )

     

    Hope this helps

3 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    5 years ago

    Anonymous 

    Try:

    New measure = 
VAR Diff = SUM('Table'[B]) - SUM('Table'[A])
RETURN
SWITCH(TRUE(),
Diff >= 2, "Investigate",
"Do Not Investigate")

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Below dax can be used as per your example:

    Column =
    IF(
    B > A + 2,
    "Investigate",
    "Do Not Investigate"
    )

     

    You can use nested If statement to have multiple conditions as shown below:

    Price Group =
    IF(
    'Product'[List Price] < 500,
    "Low",
    IF(
    'Product'[List Price] < 1500,
    "Medium",
    "High"
    )
    )

     

    Hope this helps

  • RolanRodrigues's avatar
    RolanRodrigues
    Frequent Visitor
    5 years ago

    You can do this by creating a column and using the following If formula:

    C = if(('Table '[b] - 'Table '[a]) = 2, "Investigate", "Do Not Investigate")

    Hope this help you 

    Have a great day