Power Query - Parameters with Error Checking (with bonus tip)
Learn how to check missing parameters using Power Query functions. Also, see how to make your M Code look beautiful. File Download Link: https://www.bcti.com/wp-content/YT_Do... 00:25 Overview of the Problem 01:55 Reviewing the Original Mission 02:19 Error Checking Date Parameters 05:54 Error Checking Text Parameters 09:19 Making M Code Beautiful
▶︎
DAX - Implicit vs Explicit Measures
▶︎
Power Query - Faster & Easier Parameters
▶︎
Power Query - Get Top N by Group
▶︎
Nested Lists in Power Query: You’ll Wish You Knew This Sooner
▶︎
Power Query - Alternate Group By Strategies
▶︎
Why Your Power Query Pivot Blows Up (and How to Fix it)
▶︎
The Crystal That Could Destroy All Medicine
▶︎
How Maxwell's Equations Were Discovered
▶︎
Power Query - Query Folding (The key to faster query execution)
▶︎
Power Query - Create a "Super" TRIM Function (plus cool trick)
▶︎
Power Query - Unlimited Formulas in 1 Step
▶︎
Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!)
▶︎
Power Query - GROUPBY Comparer Function Argument (Creating Bin Ranges)
▶︎
My 3 SECRETS for Power BI Parameters You MUST TRY!
▶︎
7 Power Query Tricks You’ll Regret Not Knowing
▶︎
Power Query - Sum Last N Columns
▶︎
Custom Comparer Function for Table.Group in Power Query M
▶︎
Power Query - Avoid "Helper Queries" (+10 Cool Tricks)
▶︎
Power Query parameters | Add flexibility to your queries | Excel Off The Grid
▶︎