Summary  
Demonstrates programmatic column creation techniques—example-driven, conditional, and custom expressions—using a functional query language to flexibly transform and augment table data.

General domain of usage  
Data transformation (ETL)

Creating new columns in Power BI’s Power Query is simple and flexible with features such as **Column by Example**, **Conditional Columns**, and **Custom Columns**.

The **Column by Example** feature lets you generate new columns by entering sample values, allowing Power Query to detect and apply the transformation automatically. **Conditional Columns** enable you to define logical rules to create values based on specific conditions, similar to using IF statements in Excel. Finally, **Custom Columns** provide full flexibility to create new fields using the **M language**, giving you complete control over data transformation logic.


What is the "Conditional Column" feature in Power Query used for?


Creating Columns