Conditional Formatting with multiple conditions

[Natedekock]

Hi, 

I am looking for help to run this code: 

= Table.AddColumn(#"Removed Columns2", "Custom", each if [#"Who is your Teacher?"] = "Sister Paulette Kirkham" and [Start Date] < 9/16/2020 then "Greg Hazard" else [#"Who is your Teacher?"])

The one condition is a text format and the other is date format which is why I believe it is not working. 

Looking forward to learning. 

Thanks in advance. 

Nate. 

[edhans · Accepted solution]

@Natedekock you have to type dates using the #date() function, so the below should work. You were comparing a date to 9 divided by 16 divided by 2020. It is jus like Excel's DATE() function, but it is #date() and is case sensitive.

= Table.AddColumn(#"Removed Columns2", "Custom", each if [#"Who is your Teacher?"] = "Sister Paulette Kirkham" and [Start Date] < #date(2020,9,16) then "Greg Hazard" else [#"Who is your Teacher?"])

[Natedekock]

Worked like a charm! 

Thank you.

[edhans]

Beautiful @Natedekock - glad I was able to help.