Скачать с ютуб How To Pick-Up Cell Value Using Power Query - Power BI & Excel Trick в хорошем качестве

How To Pick-Up Cell Value Using Power Query - Power BI & Excel Trick

Hey, data wizards! 🧙‍♂️ Welcome back to the channel! In today's video, we're unleashing the magic of Power Query with a super cool trick💥🔮 Tired of manual data entry and copy-pasting cell values between tables? Yeah, I feel you! But fear not, because Power Query is here to save the day! 🦸‍♂️💪 I'll walk you through this nifty technique step by step, making it super easy to follow along, even if you're new to the world of data manipulation. Power Query is like a secret weapon for data enthusiasts like us. It lets you clean, transform, and reshape data with ease! In the video, we'll dive right into a practical example where you need to extract specific cell values from one table and convert them into a column. Power Query has got your back! 💰📈 By the end of this tutorial, you'll be a Power Query maestro, effortlessly picking up cell values like a pro! So, hit that play button, and let's get started on this data adventure together! 🎥🚀 I hope you enjoy this one! Have a good one, Roland 💪 New videos coming every week 🤹‍♂‍ 🤘 New short videos coming every week 👨‍🏫 🔗MS Learn Record Functions: https://learn.microsoft.com/en-us/pow... 🎬 MORE VIDEOS: Power BI & Power Automate - How to automate reporting process -    • Power BI & Power Automate - How to automat...   Get data from folder 🔨 / Combine multiple Excel files 🔧 -    • Get data from folder 🔨 / Combine multiple ...   Dynamic Row-level Security 🔐 - Based on Dimension Tables -    • Dynamic Row-level Security 🔐 - Based on Di...   Chapters: 00:00 Topic Of The Day - Pick-up a Cell in Power Query 00:38 Intro 00:49 BI-Lingual Analytics 01:08 Excel Invoice - Pivot Table Format 01:50 Dummy Invoices / Files 02:21 Import Files From a Folder 02:40 Manual Fix - Copying dates 03:09 Pick-up Cell Value Automatically 06:30 Final Result - Cost Trend Analysis 06:49 What Data Can Be Converted? 07:21 Date Table (!!!) 07:48 Questions? Comments? 08:00 End ▼▼▼▼▼▼▼▼▼ Make sure to hit the 👍 button and ❗❗ SUBSCRIBE ❗❗ to my channel. If you have any questions, just let me know either in the comments down below 👇 or send us an e-mail 📩. ▲▲▲▲▲▲▲▲▲ 🤝 HOW TO CONNECT 🤝 LinkedIn -   / bilingualanalytics   Twitter -   / bilanalytics   Subscribe -    / @bilingualanalytics   ABOUT ME: https://bilingualanalytics.com.au/abo... 📍 – Sydney, Australia 📽 GEAR: 📷 – Sony ZV-E10 🎙 – Audio Technica AT2020 🔦 – Neewer 18” Ring Light, Elgato Key Light 🎧 – BOSE QC35 🖥 – ASUS VC279H + Xiaomi Mi Curved 34" 💻 – Intel i7-12700K, Gigabyte Aorus Master 3080 12GB, Corsair Vengeance LPX 64GB, Samsung 980Pro 1TB #PowerBI #PowerQuery #Excel