In Power Query Editor, which tab would you use to create a derived column based on a conditional statement?

In Power Query Editor, which tab would you use to create a derived column based on a conditional statement?

• A. Home
• B. Transform
• C. Add column
• D. View

Answer: (C)

To build a new column whose values come from a condition, you create a derived column by adding a new column and defining its value with a conditional rule. The tab that contains this capability is Add Column, where you can choose Conditional Column (for if/then/else rules) or use Custom Column for a broader M expression. The other tabs serve different tasks: Home for general actions, Transform for altering existing columns, and View for UI options. So the Add Column tab is the place to create a derived column based on a conditional statement.

To build a new column whose values come from a condition, you create a derived column by adding a new column and defining its value with a conditional rule. The tab that contains this capability is Add Column, where you can choose Conditional Column (for if/then/else rules) or use Custom Column for a broader M expression. The other tabs serve different tasks: Home for general actions, Transform for altering existing columns, and View for UI options. So the Add Column tab is the place to create a derived column based on a conditional statement.