Combining Tables and keep context in Power Query M (Table.FromPartitions trick!)
Автор: BI Gorilla
Загружено: 2025-04-16
Просмотров: 5177
Описание:
When you combine tables into a unified one, it's often useful to know where the table came from. One approach would be to specify a category to each of the tables before combining them. But if you don't want to clutter your original tables, there's another approach. Check out the video to understand how!
I'm one of the authors of 'The Definitive Guide to Power Query M. If you want to improve your M language skills, you can get a copy here: https://geni.us/ODZl8
ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
Website: https://gorilla.bi
SUBSCRIBE TO MY CHANNEL
https://youtube.com/bigorilla?sub_con...
TIMESTAMPS
00:00 Introduction
00:19 The problem with combining tables
02:04 Storing context with Table.FromPartitions
04:28 Setting a data type
LET'S CONNECT:
Blog: https://gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#combineTables #powerquery #m
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: