Mimic a SWITCH function in Power Query using Record.FieldOrDefault Share: Download MP3 Similar Tracks Formatting Dates with Custom Format Strings in Power Query M BI Gorilla Understanding CALCULATE in DAX: Filters BI Gorilla Creating a SWITCH Function with Conditions in Power Query M BI Gorilla Rick v/s Chandeep v/s Melissa | Who will win? Power Query Tricks Battle 3 ⚔ | @BIGorilla Goodly Formula Firewall: Referencing other Partitions in Power Query BI Gorilla Configuring Incremental Refresh in Power BI BI Gorilla Make your Group By Operations Dynamic in Power Query M BI Gorilla SWITCH Function in Power Query Goodly Create a Join based on Date Range in Power Query BI Gorilla Concatenate values in Power Query M | Avoid these pitfalls! BI Gorilla R programming for ABSOLUTE beginners R Programming 101 Understanding Enumerations in Power Query M BI Gorilla Custom Comparer Function for Table.Group in Power Query M BI Gorilla Understanding Metadata in Power Query M BI Gorilla Excel Power Query Tutorial - M Language Learn Google Sheets & Excel Spreadsheets Excel LAMBDA - HOW & WHEN you Should use it Leila Gharani Replacing Multiple Substrings in Power Query M BI Gorilla Introducing Power Query How (Master the M language) BI Gorilla Power BI Tips and Tricks Kevin Stratvert