Search if statement with multiple conditions

Question

I'm trying to create a calculated column with 2 IF conditions:

1. [GRADE_NAME] must contain "Industry"

2. 10 Years of service

However if I run this:

Column = IF(ISERROR(

SEARCH("Industr",'Query1'[GRADE_NAME]) && 'Query1'[Total Years - Employment] >= 10),CALCULATE(25.5/12),2.5)

I get:

GRADE_NAME	Total Years - Employment	Column
abcde	8.4	2.125
fghij	5.1	2.125
Industry X	9.3	2.5
Industry Y	18.5	2.5

Industry X should be showing 2.125 as they haven't served for 10 years

Is there a way to make this if statement respect both conditions e.g. they must be Industry && 10 years of service not either?

mahoneypat · Accepted Answer

Please try this column expression to get your desired result
&nbsp;
NewColumn&nbsp;=IF&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;SEARCH&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"Industr",&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Query1'[GRADE_NAME],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;)&nbsp;&gt;&nbsp;0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;'Query1'[Total&nbsp;Years&nbsp;-&nbsp;Employment]&nbsp;&gt;=&nbsp;10,&nbsp;&nbsp;&nbsp;&nbsp;2.5,&nbsp;&nbsp;&nbsp;&nbsp;DIVIDE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;25.5,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12&nbsp;&nbsp;&nbsp;&nbsp;))
&nbsp;
Regards,
Pat

Forum Discussion

Search if statement with multiple conditions

1 Reply

Related content

Multiple conditions Index

Multiple Condition If Statements

Multiple Donut charts with conditions

IF statement with multiple conditions

DAX For Multiple IF Statements and Conditions