Power BI Power Query Full Course (2026) | Data Cleaning, Merge, Append, Date Functions

In this full Power BI Power Query tutorial, you’ll learn how to perform data cleaning, data transformation, merge queries, append queries, and advanced date functions step by step. Whether you're a beginner or looking to level up your data analytics skills, this video covers everything you need to become confident in Power BI data transformation.

This is a complete Power Query full course designed for students, analysts, and job seekers who want to build real-world data analysis skills using Power BI.

Below are the topics covered in this video:
00:00 – Introduction & video overview
00:31 – Creating new columns using formulas
00:59 – Recap & Query Editor continuation
01:28 – Topics: Merge, Append, Date options
01:56 – Dataset overview before cleaning
02:28 – Data types & transform options
03:01 – Date column transformations intro
03:38 – Add Column vs Transform difference
04:13 – Age calculation from date
04:51 – Extracting date only
05:27 – Extracting year
06:05 – Start & end of year
06:42 – Month extraction basics
07:13 – Start & end of month
07:45 – Use cases of month analysis
08:20 – Monthly aggregation explanation
08:54 – Days in month
09:29 – Month name extraction
10:09 – Importance of month names
10:39 – Quarter concept explanation
11:08 – Financial year differences
11:46 – Start & end of quarter
12:21 – Quarter examples (US vs India)
12:52 – Week options intro
13:40 – Week of year
14:20 – Week of month
14:52 – Start & end of week
15:30 – Day-level options
16:02 – Day, day of week, day of year
16:46 – Explanation of weekday numbering
17:20 – Full recap of date breakdown
17:52 – Summary of date transformations
18:32 – Merge columns introduction
19:08 – Practical merge columns example
19:47 – Result of merged columns
20:19 – Merge = concatenation
20:55 – Merge columns vs merge queries
21:29 – Append queries concept
22:33 – Combining datasets (append)
23:04 – Append query demo
23:35 – Result of appended data
24:08 – Merge queries introduction
24:42 – Product vs store dataset explanation
25:11 – Need for joins
25:46 – Merge query setup
26:21 – Join types explanation
26:53 – Left join explanation
27:30 – Expanding merged columns
28:02 – Final merged dataset output
28:43 – Using Python & R scripts
29:19 – Time transformation options
29:54 – Extracting time components
30:30 – Moving to Add Column tab
30:58 – General add column overview
31:29 – Duplicate column
32:06 – Index column basics
32:56 – Importance of index
33:25 – Custom index creation
33:54 – Conditional column intro
34:30 – Conditional logic example
35:05 – High/Medium/Low classification
35:42 – Use case of conditional grouping
36:12 – Add column from example
36:52 – Custom function usage
37:24 – Custom column with IF condition
38:14 – Boolean (true/false) column example
40:58 – Output of conditional column
41:26 – Profit percentage calculation
42:08 – Custom calculation result
42:40 – Summary of Add Column features
43:11 – Refresh & query properties
43:39 – Advanced editor (M language)
44:09 – Query management options
44:39 – Data source settings
45:08 – View tab options
45:42 – Column profiling & quality
46:10 – Query dependencies
46:35 – Closing & applying changes

▶️ What You’ll Learn in This Video:
- Power BI Power Query basics for beginners
- Data cleaning techniques in Power BI
- Difference between Add Column vs Transform
- Date transformations (Year, Month, Quarter, Week, Day analysis)
- Merge columns vs Merge queries
- Append queries (combining datasets)
- Join types in Power BI (Left Join and more)
- Conditional columns and custom columns
- Index columns and data modeling basics
- Advanced Editor and M Language introduction
- Query dependencies and data profiling

▶️ Why This Video Matters:
Power Query is the backbone of data transformation in Power BI. Mastering it will help you:
- Clean messy datasets efficiently
- Build professional dashboards
- Perform advanced data analysis
- Improve your chances of getting hired in data roles

Видео Power BI Power Query Full Course (2026) | Data Cleaning, Merge, Append, Date Functions канала upGrad Learning