![excel 2016 query editor insert a new step excel 2016 query editor insert a new step](https://excelquick.com/wp-content/uploads/2020/03/power-query-editor-window_1.png)
Date: is before, is after, is equal to, does not equal, etc.Numbers: equals, does not equal, is bigger than or equal to, etc.Text: begins with, does not begin with, equals, contains, etc.Operator: selections depend on the data type of the select Column Name.Column Name: The column to evaluate your if-condition against.New Column Name: Enter the name for your new column.You can use this menu to set up conditional logic. It allows you to create basic if-statements.Īfter clicking on Condition Column, the Add Conditional Column menu pops up: You can go to the Add Column tab in Power Query, and click on Conditional Column. The easiest way to add a conditional statement is by using a Conditional Column. Using the user interface one could either add a Conditional Column or write it from scratch by adding a Custom Column. You can find both in the Add Column tab in the Power Query ribbon. There are two easy ways to add an if-statement. These show the start and end of the function.Ģ. The words if and else determine the beginning and end of an if function.Īrguments are always provided between parentheses. Separates arguments by a default separator.
![excel 2016 query editor insert a new step excel 2016 query editor insert a new step](https://miro.medium.com/max/678/1*WSuMzkUIT26j1GbpsSOqkw.png)
Separates arguments by the lowercase words then and else. Yet Excel automatically converts lowercase to uppercase. Capitalizing any letter in the words if, then, and else throws an error. The if function in Power Query differs from Excel in three ways.