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
Go to 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
View solution in original post
New measure =
VAR Diff = SUM('Table'[B]) - SUM('Table'[A])
Diff >= 2, "Investigate",
"Do Not Investigate")
Proud to be a Super User!Paul on Linkedin.
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
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.