The let-expression in Power Query M Explained
Create a blank query in Power Query, and you immediately see a let expression. But does every query need one? In this video, we break down what a let expression really is, the structure, how it works, common issues and how to resolve them. CHAPTERS 00:00:00 - Intro, let, a fundamental concept in M 00:01:22 - Steps, Variables, Identifiers, Expressions, and Values 00:03:42 - The comma rule 00:05:00 - Referring to values in M 00:07:53 - Scope in nested expressions 00:08:46 - How a let expression works 00:10:28 - Debugging with records CODE SAMPLES github.com/m-dekorte/melissa-de-korte-youtube-resources CONNECT linkedin.com/in/melissa-de-korte-64585884/ #PowerQuery #MLanguage #Fundamental
▶︎
Fixed-Width Text Files in Power Query: a Dynamic Solution
▶︎
Too Many Parameters? Use This Pattern
▶︎
Power BI Calculated Columns vs Measures | Explicit vs Implicit Measures
▶︎
Unpivot Multiple Column Pairs Dynamically in Power Query
▶︎
Using a Mapping Table to Manage Column Names and Data Types in Power Query
▶︎
List.Zip in Power Query. What It Does and What Can Go Wrong.
▶︎
The Scariest Chart In Electrical Engineering
▶︎
System Design Explained: APIs, Databases, Caching, CDNs, Load Balancing & Production Infra
▶︎
MIT Professor: Leetcode, P vs NP, SAT Solvers | Ryan Williams
▶︎
I finally understood why the universe needs imaginary numbers (My mind is blown!)
▶︎
Making Materialized Views Actually Fast with DBSP (with Lalith Suresh)
▶︎
Only Video That Will Make You BETTER at MATH - 100%
▶︎
Task vs ValueTask in C#
▶︎
The each Keyword in Power Query M Explained
▶︎
Don’t Use Boolean Flags in Python, Use Policies Instead
▶︎
The Shape that Broke Math
▶︎
The Story of C++: The World's Most Consequential Programming Language | The Official Story
▶︎
Scott Ritter: Russland gewinnt den Krieg – und das eindeutig
▶︎
System Design Explained: APIs, Databases, Caching, CDNs, Load Balancing & Production Infra
▶︎