IF Statement Custom Column

[swhittington]

Hello! I am trying to write an IF statement that will look at multiple columns to determine the appropriate input. 

I want the formula to see if that ad group (column 1) has a responsive search ad (column 2) that is active (column 3) then input yes, if not input no. 

Thank you!

[sevenhills · Accepted solution]

For the column syntax (not measure), try this:

Ad Group Contains Active Responsive Search Ad? = 

var _AdGroup = 'Table'[Ad Group]

var _Conditon_check = CALCULATE( COUNTROWS('Table'), Filter(All('Table'), 'Table'[Ad Group] = _AdGroup && 'Table'[Ad Type] = "Responsive Search Ad" && 'Table'[Status] = "Active") )

RETURN IF ( _Conditon_check >= 1, "Yes", "No")

 Output: