OmidBI

2.84K subscribers

175 videos

Welcome to Power-M-Query– channel for mastering data transformation and automation in Excel and Power BI! Whether you're a beginner just getting started with...

Latest Videos

Split Comma-Separated Values into Rows in Power Query

Transform Irregular Tables into Structured Data in Power Query

Split Words into a Pyramid in Power Query Using List.Transform

Find the Latest Status per ID in Power Query (Table.Group + Table.Max)

Dynamic Column Reordering in Power Query (Data-Driven Structure)

Convert Messy Tables into Structured Data in Power Query

Group Rows and Combine Text Values in Power Query

Power Query Trick Remove Text and Leading Zeros from IDs

interactive Excel Chart Select Chart Axes with a Dropdown

Conditional Formatting in Excel Column Charts Target-Based Colors

Control Excel Chart Lines with Checkboxes Dynamic Visualization

Create a Dynamic Excel Chart Update Date Range Automatically

Top N per Month in Power Query (Group Remaining Products as Others)

4 Smart Power Query Tips to Write Cleaner, Faster, and More Robust M Code

Power Query Column Splitting Explained - Complete Guide from Basics to Advanced

Power Query Advanced Replacer Replace Whole Cells with Null Using Custom Functions

Power Query Pro Tip Using Empty Lists for Cleaner, Safer Data Transformations

Clean Super Messy Tables Using List.Transform & List.Skip (Advanced M Code Tutorial)

Replace Several Values in a Column in Power Query with One Step

Clean a Table with Offset Columns Like a Pro! Power Query Challenge 303

Split Columns Like a Pro in Power Query! Custom Splitter Function

Master Column Referencing in Power Query Table.Column, SelectColumns, RemoveColumns, Index Access

4 Smart Ways to Refer to Other Rows in Power Query Merge, Filter, List functions, and Fill Down

Split Columns Like a PRO in Power Query Custom Splitter with Table.SplitColumn

Remove Duplicate Rows in Power Query Using a Custom Condition

Power Query Magic for Transforming a Supper Messy Table into Clean Data with Ease!

Merge Columns in Power Query Dynamically Based on Name Patterns

Everything You Need to Know About Creating Custom Functions in Power Query

Find Missing Dates in Power Query Append, Merge & List.Difference Explained

Power Query Trick Dynamically Add Multiple Columns with List.Accumulate