Канал: Brian Grant

Rename Steps And Describe Query - Custom Column - Power Query Jumpstarter

Rename Steps And Describe Query - Custom Column - Power Query Jumpstarter

User Function Return Record (Power Query Jumpstarter)

User Function Return Record (Power Query Jumpstarter)

User Function Multi Step (Power Query Jumpstarter)

User Function Multi Step (Power Query Jumpstarter)

User Function Simple (Power Query Jumpstarter)

User Function Simple (Power Query Jumpstarter)

Query as Function (Power Query Jumpstarter)

Query as Function (Power Query Jumpstarter)

Query as a Function Practical (Power Query Jumpstarter)

Query as a Function Practical (Power Query Jumpstarter)

User Function Intermediate (Power Query Jumpstarter)

User Function Intermediate (Power Query Jumpstarter)

Usage of the Pivot Columns Transformation

Usage of the Pivot Columns Transformation

Basic Unpivot Columns Second Example

Basic Unpivot Columns Second Example

How Unpivot Columns Deals with Creeping Columns

How Unpivot Columns Deals with Creeping Columns

Basics of the Unpivot Columns Transformation

Basics of the Unpivot Columns Transformation

Duplicate Row Handling in Unpivot Columns

Duplicate Row Handling in Unpivot Columns

Pivot Columns Given Duplicate Label Rows

Pivot Columns Given Duplicate Label Rows

Null Values in Unpivot Columns

Null Values in Unpivot Columns

Merging Sale with Product Table (Left Outer Join) - Joining and Merging - Power Query Jumpstarter

Merging Sale with Product Table (Left Outer Join) - Joining and Merging - Power Query Jumpstarter

Combine All Worksheets in Workbook - Combining Data - Power Query Jumpstarter

Combine All Worksheets in Workbook - Combining Data - Power Query Jumpstarter

Combine Workbooks in a Folder - Combining Data - Power Query Jumpstarter

Combine Workbooks in a Folder - Combining Data - Power Query Jumpstarter

Sales Growth From Last Week - Intermediate Previous Step Reference - Power Query Jumpstarter

Sales Growth From Last Week - Intermediate Previous Step Reference - Power Query Jumpstarter

Merge Multiple Dimension Tables (Left Outer Join) - Joining and Merging - Power Query Jumpstarter

Merge Multiple Dimension Tables (Left Outer Join) - Joining and Merging - Power Query Jumpstarter

Adding a Sales Increase Column - A Basic Previous Step Reference - Power Query Jumpstarter

Adding a Sales Increase Column - A Basic Previous Step Reference - Power Query Jumpstarter

Percent of Total Sales Column - Previous Step References - Power Query Jumpstarter

Percent of Total Sales Column - Previous Step References - Power Query Jumpstarter

Top 100 Customers With Emails (Inner Join) - Joining and Merging - Power Query Jumpstarter

Top 100 Customers With Emails (Inner Join) - Joining and Merging - Power Query Jumpstarter

Combining / Stacking 3 Monthly Sales Tables - Advanced Table Expansion - Power Query Jumpstarter

Combining / Stacking 3 Monthly Sales Tables - Advanced Table Expansion - Power Query Jumpstarter

Find Top Selling Product Per Category - Advanced Table Expansion - Power Query Jumpstarter

Find Top Selling Product Per Category - Advanced Table Expansion - Power Query Jumpstarter

Record Expansion Basic & Intermediate - Record, List, & Table Expansions - Power Query Jumpstarter

Record Expansion Basic & Intermediate - Record, List, & Table Expansions - Power Query Jumpstarter

Normalizing Mid Month Costs - Record, List, & Table Expansions - Power Query Jumpstarter

Normalizing Mid Month Costs - Record, List, & Table Expansions - Power Query Jumpstarter

Distinct Orders From A Transaction Table - Group By - Power Query Jumpstarter

Distinct Orders From A Transaction Table - Group By - Power Query Jumpstarter

Total & Average Sales by State then Category - Group By - Power Query Jumpstarter

Total & Average Sales by State then Category - Group By - Power Query Jumpstarter

Intro to List Expansions - Record, List, & Table Expansions - Power Query Jumpstarter

Intro to List Expansions - Record, List, & Table Expansions - Power Query Jumpstarter

Product Sales Rank by Category - Record, List, & Table Expansions - Power Query Jumpstarter

Product Sales Rank by Category - Record, List, & Table Expansions - Power Query Jumpstarter

Intro to Table Expansions - Record, List, & Table Expansions - Power Query Jumpstarter

Intro to Table Expansions - Record, List, & Table Expansions - Power Query Jumpstarter

Total Sales and Most Store Employees By State and Capacity - Group By - Power Query Jumpstarter

Total Sales and Most Store Employees By State and Capacity - Group By - Power Query Jumpstarter

Introduction to Group By - Group By - Power Query Jumpstarter

Introduction to Group By - Group By - Power Query Jumpstarter

Referencing Steps With Names That Have Spaces (M) - Queries By Hand - Power Query Jumpstarter

Referencing Steps With Names That Have Spaces (M) - Queries By Hand - Power Query Jumpstarter

Extract Rows From Tables - Extracting Values - Power Query Jumpstarter

Extract Rows From Tables - Extracting Values - Power Query Jumpstarter

Extract Single Values From Tables - Extracting Values - Power Query Jumpstarter

Extract Single Values From Tables - Extracting Values - Power Query Jumpstarter

Flagging New Products With If Then Else - Custom Columns - Power Query Jumpstarter

Flagging New Products With If Then Else - Custom Columns - Power Query Jumpstarter

Extracting With A Key Search - Extracting Values - Power Query Jumpstarter

Extracting With A Key Search - Extracting Values - Power Query Jumpstarter

Working With Table Functions By Hand (M) - Queries By Hand - Power Query Jumpstarter

Working With Table Functions By Hand (M) - Queries By Hand - Power Query Jumpstarter

Introduction to Handmade Queries (M) - Queries By Hand - Power Query Jumpstarter

Introduction to Handmade Queries (M) - Queries By Hand - Power Query Jumpstarter

Extract Columns From Tables - Extracting Values - Power Query Jumpstarter

Extract Columns From Tables - Extracting Values - Power Query Jumpstarter

Fill Down and Fill Up - Simple Toolbar Transformations - Power Query Jumpstarter

Fill Down and Fill Up - Simple Toolbar Transformations - Power Query Jumpstarter

Intro to Custom Columns aka Total Sales and Sales Per SF - Custom Columns - Power Query Jumpstarter

Intro to Custom Columns aka Total Sales and Sales Per SF - Custom Columns - Power Query Jumpstarter

Time Transformations - Simple Toolbar Transformations - Power Query Jumpstarter

Time Transformations - Simple Toolbar Transformations - Power Query Jumpstarter

New Store Sales Growth aka Fix Errors With Try Otherwise - Custom Columns - Power Query Jumpstarter

New Store Sales Growth aka Fix Errors With Try Otherwise - Custom Columns - Power Query Jumpstarter

Change Text to UPPER lower & Proper Case - Simple Toolbar Transformations - Power Query Jumpstarter

Change Text to UPPER lower & Proper Case - Simple Toolbar Transformations - Power Query Jumpstarter

Removing Excess Spaces with Trim - Simple Toolbar Transformations - Power Query Jumpstarter

Removing Excess Spaces with Trim - Simple Toolbar Transformations - Power Query Jumpstarter

Special Text Filters - Simple Toolbar Transformations - Power Query Jumpstarter

Special Text Filters - Simple Toolbar Transformations - Power Query Jumpstarter

Special Date FIltering - Simple Toolbar Transformations - Power Query Jumpstarter

Special Date FIltering - Simple Toolbar Transformations - Power Query Jumpstarter

Add Indexes - Simple Toolbar Transformations - Power Query Jumpstarter

Add Indexes - Simple Toolbar Transformations - Power Query Jumpstarter

Date Transformation Columns - Simple Toolbar Transformations - Power Query Jumpstarter

Date Transformation Columns - Simple Toolbar Transformations - Power Query Jumpstarter

Remove Top Rows & Promote Headers - Simple Toolbar Transformations - Power Query Jumpstarter

Remove Top Rows & Promote Headers - Simple Toolbar Transformations - Power Query Jumpstarter

Keep Errors and Remove Errors - Simple Toolbar Transformations - Power Query Jumpstarter

Keep Errors and Remove Errors - Simple Toolbar Transformations - Power Query Jumpstarter

ReplaceValuesAndErrors

ReplaceValuesAndErrors

Column Split By aka Text To Columns - Simple Toolbar Transformations - Power Query Jumpstarter

Column Split By aka Text To Columns - Simple Toolbar Transformations - Power Query Jumpstarter

Replacing Values and Replacing Errors - Simple Toolbar Transformations - Power Query Jumpstarter

Replacing Values and Replacing Errors - Simple Toolbar Transformations - Power Query Jumpstarter

Use Header as First Row & Transpose Table - Simple Toolbar Transformations - Power Query Jumpstarter

Use Header as First Row & Transpose Table - Simple Toolbar Transformations - Power Query Jumpstarter

Sorting By One or Multiple Columns - Simple Toolbar Transformations - Power Query Jumpstarter

Sorting By One or Multiple Columns - Simple Toolbar Transformations - Power Query Jumpstarter

Intro to Power Query: Your First Query - Power Query Jumpstarter

Intro to Power Query: Your First Query - Power Query Jumpstarter

Exceleration 40 - Return Function as Record for Better Transparency aka Setting Record Straight

Exceleration 40 - Return Function as Record for Better Transparency aka Setting Record Straight

Excel and Power BI Speed Through Demo

Excel and Power BI Speed Through Demo

Exceleration 38 - Combine Sheets with Sheet Name

Exceleration 38 - Combine Sheets with Sheet Name

Exceleration 39 Row And-Logic Filtering

Exceleration 39 Row And-Logic Filtering

Exceleration 37 - Dirty Time Text aka DateTime Cop

Exceleration 37 - Dirty Time Text aka DateTime Cop

Exceleration 36 - Extracting Data from Subtotal/Group Rows aka Floating Point Break

Exceleration 36 - Extracting Data from Subtotal/Group Rows aka Floating Point Break

Exceleration 35 - Understanding RANKX Value aka The Argument Who Wasn't There

Exceleration 35 - Understanding RANKX Value aka The Argument Who Wasn't There

Exceleration 33 - Summary Table With Crossjoin aka Acrossjoin the Universe

Exceleration 33 - Summary Table With Crossjoin aka Acrossjoin the Universe

Exceleration - 32 OU Avg Sales

Exceleration - 32 OU Avg Sales

Exceleration 31 - Percent of Total via PowerQuery

Exceleration 31 - Percent of Total via PowerQuery

Exceleration 30 - Running Total aka Logan's Metric

Exceleration 30 - Running Total aka Logan's Metric

Exceleration 29 - Last Week Worked via PowerQuery aka So Darling, Save the Last Week for Me

Exceleration 29 - Last Week Worked via PowerQuery aka So Darling, Save the Last Week for Me

Exceleration - 28 Last Week Worked (Array Method) aka The Weekend Array Warrior

Exceleration - 28 Last Week Worked (Array Method) aka The Weekend Array Warrior

Exceleration 26 - Categorize Using Unpivot aka Unpivot My dimCat[Name]="Heart"

Exceleration 26 - Categorize Using Unpivot aka Unpivot My dimCat[Name]="Heart"

Exceleration 27 - Grabbing Data from Table Junk aka Save the Date

Exceleration 27 - Grabbing Data from Table Junk aka Save the Date

Exceleration 25 - Clean & Combine a Folder of Dirty Workbooks aka This is from... Mathilda

Exceleration 25 - Clean & Combine a Folder of Dirty Workbooks aka This is from... Mathilda

Exceleration 24 - Good Looking Tables for Screens aka 256 Shades of Grey

Exceleration 24 - Good Looking Tables for Screens aka 256 Shades of Grey

Exceleration 21 - Why Power Query?

Exceleration 21 - Why Power Query?

Exceleration 23 Inner Join via M aka Through a GUI Darkly

Exceleration 23 Inner Join via M aka Through a GUI Darkly

Exceleration 22 - Inner Join via Power Query aka Back to the Future

Exceleration 22 - Inner Join via Power Query aka Back to the Future

Exceleration 20 - Inner Join Tables aka Spreadsheet Time Machine

Exceleration 20 - Inner Join Tables aka Spreadsheet Time Machine

Exceleration 19 - Insert Multiples Copies of a Row AKA Attack of the Clones

Exceleration 19 - Insert Multiples Copies of a Row AKA Attack of the Clones

Exceleration 18 - A Charting Matter of Great (Figurative) Significance aka Just Show Me Millions

Exceleration 18 - A Charting Matter of Great (Figurative) Significance aka Just Show Me Millions

Exceleration 17 - Reporting On A Budget: Report Hard with a Variance

Exceleration 17 - Reporting On A Budget: Report Hard with a Variance

Exceleration 16 - Reporting On A Budget 2 The Quickbookening

Exceleration 16 - Reporting On A Budget 2 The Quickbookening

Exceleration 15 - Estimates, Actuals, and all the Columns in Between aka Reporting On A Budget

Exceleration 15 - Estimates, Actuals, and all the Columns in Between aka Reporting On A Budget

Exceleration 14 - Setting a Higher Bar for Bars

Exceleration 14 - Setting a Higher Bar for Bars

Count of Active Customers

Count of Active Customers

Total Margin With Slicer

Total Margin With Slicer

Days Selling To Customer v2 0

Days Selling To Customer v2 0

Days Selling

Days Selling

Total Sales YTD

Total Sales YTD

Total Sales Equivelent Period Last Month

Total Sales Equivelent Period Last Month

Summaraize v Crossjoin

Summaraize v Crossjoin

Total Sales Same Month Last Year

Total Sales Same Month Last Year

last Month Sales v2 0

last Month Sales v2 0

CrossJoin 1 0

CrossJoin 1 0

last Month Sales

last Month Sales

Exceleration Episode 13 - In Formula Comments for Numbers, Text, and Mixed Formulas

Exceleration Episode 13 - In Formula Comments for Numbers, Text, and Mixed Formulas

Exceleration Episode 12 - Focus on the Positives

Exceleration Episode 12 - Focus on the Positives

Exceleration Episode 11 - Iteration by Code

Exceleration Episode 11 - Iteration by Code

Exceleration Episode 10 - Extracting Middle and Last Names

Exceleration Episode 10 - Extracting Middle and Last Names

Exceleration Episode 9 - Flagging Last Thursdays and Second Wednesdays

Exceleration Episode 9 - Flagging Last Thursdays and Second Wednesdays

Exceleration Episode 8 - Storing the Cross-Tab Unwinder in a Text Document for Quick Use.

Exceleration Episode 8 - Storing the Cross-Tab Unwinder in a Text Document for Quick Use.

Exceleration Episode 7 - Unwinding Cross-tabular Data

Exceleration Episode 7 - Unwinding Cross-tabular Data

Exceleration Episode 6 - Locating Text Strings Masquerading as Dates

Exceleration Episode 6 - Locating Text Strings Masquerading as Dates

Exceleration Episode 5 - Checking for match numbers within a row.

Exceleration Episode 5 - Checking for match numbers within a row.

Exceleration Episode 4 Non Unique Elements Between Two List Rows

Exceleration Episode 4 Non Unique Elements Between Two List Rows

Exceleration Episode 3 - Generate a large number of worksheets from a list.

Exceleration Episode 3 - Generate a large number of worksheets from a list.

Exceleration Episode 2 Serial Number by Day

Exceleration Episode 2 Serial Number by Day

Excelaration 1 - A Single Formula for Several Descriptive Statistics

Excelaration 1 - A Single Formula for Several Descriptive Statistics