Forum Discussion

Anonymous

Not applicable

2 years ago

Solved

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

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
2 years ago
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
Not applicable
2 years ago
Don't worry, I've worked it out!
- Anonymous
  Not applicable
  2 years ago
  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
Anonymous
Not applicable
2 years ago
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)