Скачать или смотреть LESSON 10260 | COLUMNS FROM EXAMPLES IN POWER QUERY | Complete Power Query Full Course

In this video, I’ll teach you how to create calculated columns in Power Query using the "Column from Examples" feature, which lets you build transformations by example—without writing any M code. I demonstrate how to reformat date columns and calculate total sales amounts by giving intuitive examples directly in the UI. You’ll see how Power Query tries to infer patterns from your inputs and generate the corresponding M functions automatically. However, I also highlight critical limitations, like incorrect pattern recognition and rounding issues, that make this feature risky for complex datasets. If you're working with large or sensitive data, it’s often better to use custom columns with explicit logic instead of relying solely on Power Query's AI-generated inferences.

📈 Get the data packs: https://immalytics.com/packs?utm_sour...

🟢 Power Query Fundamentals Playlist: 👉🏻    • POWER QUERY COMPLETE FREE COURSE  
🟣 DAX Foundations Playlist: 👉🏻    • DAX FOUNDATIONS  
🟡 Power BI Playlist: 👉🏻    • POWER BI FROM A TO Z  

💻 For all playlists, visit our website: https://immalytics.com

Chapters
00:00 How to Add Calculated Columns in Power Query Using Examples
00:20 Loading sales data into Power Query from Excel
01:20 Using "Add Column from Examples" in Power Query
03:10 Power Query misunderstands the date pattern
05:30 Reviewing the generated M function behind the scenes
06:00 Warning
07:00 Starting a second example: Calculating sales amount
08:30 One major mistake: incorrect multiplication result spotted
09:00 Warning: Even if early rows look right, scroll through all data
11:00 Summary: Use examples for simplicity, custom columns for accuracy

#powerquery #powerbi #freecourseimmalytics #powerqueryeditor #powerquerycourse