Mimic a SWITCH function in Power Query using Record.FieldOrDefault

BI Gorilla November 17, 2024
Video Thumbnail
BI Gorilla Logo

BI Gorilla

View Channel

About

Thanks for checking out BI Gorilla on YouTube! My name is Rick de Groot and my goal is to help professionals like you advance your skills to the next level with Power BI. I look at issues users run into and provide them with ready to use solutions so you can shape your data and make accurate decisions. 👉 Join me by subscribing and participating in the comments with your questions or thoughts. Visit my websites: https://powerquery.how - to learn all about function syntax and examples https://gorilla.bi - to get more in-depth articles and videos. Keep crushing it — talk soon! @Rickmaurinus

You May Also Like

Power Query Must-Haves

AI-recommended products based on this video

Loading...
VINTAR South Africa Plug Adapter,VINTAR Type M Power Adapter with 1 USB C,2 American Outlets and 3 USB Ports,6 in 1 International Power Adapter for Canada to South Africa,Botswana,Namibia,Nepal(Type M)

VINTAR South Africa Plug Adapter,VINTAR Type M Power Adapter with 1 USB C,2 American Outlets and 3 USB Ports,6 in 1 International Power Adapter for Canada to South Africa,Botswana,Namibia,Nepal(Type M)

(2,588)
$22.99
FREE delivery Sat, Jun 14 on your first order
Loading...
YKYI Electric Spin Scrubber-New Roller Type, Shower Scrubber with Long Handle, Electric Cleaning Brush with 4 Replaceable Brush Heads & Adjustable Power Scrubber for Shower, Bathtub,Tile, Floor(White)

YKYI Electric Spin Scrubber-New Roller Type, Shower Scrubber with Long Handle, Electric Cleaning Brush with 4 Replaceable Brush Heads & Adjustable Power Scrubber for Shower, Bathtub,Tile, Floor(White)

(272)
$47.47
FREE delivery Tue, Dec 30
Loading...
Vacuum Sealer for Food,75Kpa Precision Suction Power 6-in-1 Food Sealer with Digital Timer, Dry & Moist Food Modes, Compact Design with 10 Vacuum Bags & Bulit-in Cutter(Black Sliver)

Vacuum Sealer for Food,75Kpa Precision Suction Power 6-in-1 Food Sealer with Digital Timer, Dry & Moist Food Modes, Compact Design with 10 Vacuum Bags & Bulit-in Cutter(Black Sliver)

(14)
$41.99
Prime
Loading...
Wireless Earbuds, Sports Bluetooth Headphones, 80Hrs Playtime Ear Buds with LED Power Display, Noise Canceling Headset, IPX7 Waterproof Earphones for Workout/Running(Black)

Wireless Earbuds, Sports Bluetooth Headphones, 80Hrs Playtime Ear Buds with LED Power Display, Noise Canceling Headset, IPX7 Waterproof Earphones for Workout/Running(Black)

(299)
$32.99
Prime
Loading...
16.4Ft/5M Long USB C Cable, Durable USB A to USB C Charging and Data Sync Cord, Power Extension Cable for Any USB-C Enabled Security Cameras Phones Tablets Switch Pro Controller and More

16.4Ft/5M Long USB C Cable, Durable USB A to USB C Charging and Data Sync Cord, Power Extension Cable for Any USB-C Enabled Security Cameras Phones Tablets Switch Pro Controller and More

(95)
$11.99
FREE delivery Sat, Jun 14 on your first order
Loading...
USB C Hub, MacBook Pro Adapter USB C Dongle with 4K HDMI,Thunderbolt 3 100W Power Delivery Port,USB C 5Gbps Data Port,SD/TF Card Reader,2 USB 3.0 Ports Compatible for MacBook Pro Air 2022/2021/2020

USB C Hub, MacBook Pro Adapter USB C Dongle with 4K HDMI,Thunderbolt 3 100W Power Delivery Port,USB C 5Gbps Data Port,SD/TF Card Reader,2 USB 3.0 Ports Compatible for MacBook Pro Air 2022/2021/2020

(4,449)
$25.99
FREE delivery Sat, Jun 14 on your first order
100+ bought in past month
Loading...
UGREEN Revodok USB C Hub, 5-in-1 USB C Adapter with 4K HDMI, 100W Power Delivery, 3 USB A Data Ports, Multiport USB Hub for MacBook Pro/Air, iPad Pro, Surface, XPS, Thinkpad, Galaxy and More, Gray
Best Seller

UGREEN Revodok USB C Hub, 5-in-1 USB C Adapter with 4K HDMI, 100W Power Delivery, 3 USB A Data Ports, Multiport USB Hub for MacBook Pro/Air, iPad Pro, Surface, XPS, Thinkpad, Galaxy and More, Gray

(17,667)
$19.99
3K+ bought in past month
Loading...
NEW POW 65W 18V-20V Universal Ultrathin AC Adapter Laptop Charger Power Supply for HP Lenovo Dell Asus Acer IBM Toshiba Samsung Sony Fujitsu Gateway Compatible Models Cord (15 Tips,Black)

NEW POW 65W 18V-20V Universal Ultrathin AC Adapter Laptop Charger Power Supply for HP Lenovo Dell Asus Acer IBM Toshiba Samsung Sony Fujitsu Gateway Compatible Models Cord (15 Tips,Black)

(962)
$26.99
FREE delivery Tue, Jun 17 on your first order
100+ bought in past month
Loading...
SAMSUNG T7 4TB, Portable SSD, Grey, up to 1050MB/s, USB 3.2 Gen2, Gaming, Students & Professionals, External Solid State Drive (MU-PC4T0T/AM), Grey [Canada Version]

SAMSUNG T7 4TB, Portable SSD, Grey, up to 1050MB/s, USB 3.2 Gen2, Gaming, Students & Professionals, External Solid State Drive (MU-PC4T0T/AM), Grey [Canada Version]

(35,672)
$449.97$389.00
FREE delivery Tue, Jun 17
200+ bought in past month
Loading...
SAMSUNG T7 Shield 4TB, Portable Solid State Drive, up-to 1050MB/s, USB 3.2 Gen2, Rugged, IP65 Water & Dust Resistant, for Photographers, Creators and Gaming, (MU-PE4T0S/AM), Black [Canada Version]

SAMSUNG T7 Shield 4TB, Portable Solid State Drive, up-to 1050MB/s, USB 3.2 Gen2, Rugged, IP65 Water & Dust Resistant, for Photographers, Creators and Gaming, (MU-PE4T0S/AM), Black [Canada Version]

(14,545)
$439.97$348.93
FREE delivery Tue, Jun 17
50+ bought in past month
Loading...
Western Digital 4TB My Passport Portable External Hard Drive HDD, USB 3.0, USB 2.0 Compatible, Black - WDBPKJ0040BBK-WESN

Western Digital 4TB My Passport Portable External Hard Drive HDD, USB 3.0, USB 2.0 Compatible, Black - WDBPKJ0040BBK-WESN

(111,552)
$154.99$139.49
FREE delivery Tue, Jun 17
100+ bought in past month
Loading...
Invincible Fitness Agility Ladder Full Training Equipment Set, Improves Coordination, Speed, Power and Strength, Includes 10 Cones 4 Hooks and 3 Loop Resistance Bands for Outdoor Workout

Invincible Fitness Agility Ladder Full Training Equipment Set, Improves Coordination, Speed, Power and Strength, Includes 10 Cones 4 Hooks and 3 Loop Resistance Bands for Outdoor Workout

(2,076)
$34.88
FREE delivery Sat, Jun 28 on your first order
100+ bought in past month
Loading...
Media Management and Artificial Intelligence: Understanding Media Business Models in the Digital Age

Media Management and Artificial Intelligence: Understanding Media Business Models in the Digital Age

(6)
$71.44$57.48
FREE delivery Tue, Jun 17
Loading...
Asus ROG Strix 1000W Gold Aura Edition (Fully Modular Power Supply, 80+ Gold Certified, ATX 3.0, Cybenetics Lambda A+ Certification, PCIe Gen 5.0 Ready, Axial-tech Fan, Aura Sync, 10-Year Warranty)

Asus ROG Strix 1000W Gold Aura Edition (Fully Modular Power Supply, 80+ Gold Certified, ATX 3.0, Cybenetics Lambda A+ Certification, PCIe Gen 5.0 Ready, Axial-tech Fan, Aura Sync, 10-Year Warranty)

(38)
$267.83$262.70
FREE delivery Oct 9 - 10