Forum Discussion

Natedekock's avatar
Natedekock
Regular Visitor
5 years ago
Solved

Conditional Formatting with multiple conditions

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. 

Need Help
  • edhans's avatar
    edhans
    5 years ago

    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?"])

     

3 Replies

  • edhans's avatar
    edhans
    Community Champion
    5 years ago

    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?"])