How to add a conditional column to use IF(AND ?

[Anonymous]

Please help, I'm very new to Power Query, absolutely loving it so far but I need a new column that says

IF Col A AND Col B = Complete THEN "Complete" ELSE "Incomplete"

I can only see a way of puting in IF statements though without an AND

Please help

[Anonymous · Accepted solution]

I eralised I could just add a normal conditional column using one IF statement then adjust the formula in the formula bar to add in the and part of the formula

= Table.AddColumn(#"Replaced Value1", "Committed Cost", each if [Calculated Status] = "Complete" and [Cmtd Total] > 1000 then [Cmtd Total] else 0)

[Anonymous]

Don't worry, I've worked it out!

[Anonymous]

Hi @Anonymous ,

Glad to hear that you have solved your problem, could you please share your solution below and mark it as a solution? I am sure your sharing will help more users who are facing the same or similar problem, thanks!

Best Regards,
Dino Tao