If Statement Power BI

[Anonymous]

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

[Anonymous · Accepted solution]

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

[PaulDBrown]

@Anonymous 

Try:

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

[RolanRodrigues]

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