Forum Discussion
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 pu...
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)
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)