8. Adding Columns: Power Query Add Column Tab and DAX Calculated Columns
8.2 Column From Examples
You type the answer, and Power Query works out the formula.
Steps in Power BI
- Select the column(s) to use, for example Customer Name (values like "Shraddha Bagale").
- Add Column › Column From Examples › From Selection (or From All Columns).
- In the new empty column type
Shraddhain the first row and press Enter. Power Query fills the other rows and shows the formula at the top (Text Before Delimiter " "). - If a row is wrong, type the correct value in that row too. Two or three examples are usually enough.
- Rename the column (double-click the header in the dialog) to First Name › OK.
| Input | You type | Power Query suggests |
|---|---|---|
| Blinkit Kothrud (Pune) | Kothrud | Text Between Delimiters " " and " (" |
| 2025-10-20 21:47 | Oct-2025 | Date.ToText with format "MMM-yyyy" |
| 480 | 400-499 | A range (bucketing) formula |
Ravindra Bagale's Tip
Ek goshta lakshat theva: accepting the first Column From Examples suggestion without reading the formula is risky. It may work for the preview rows but fail for others (udaharan mhanje names without a space). Type two or three examples, then read the formula shown at the top before clicking OK. He exam aani interview doghansathi important aahe.
Practice task
From Store ID "BLK-PUN-KOT-01", use Column From Examples to get the City Code "PUN".