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 au...
Get data from folder 🔨 / Combine multiple Excel files 🔧 - • Get data from folder 🔨 / Combine mult...
Dynamic Row-level Security 🔐 - Based on Dimension Tables - • Dynamic Row-level Security 🔐 - Based ...
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