Merge Queries Power BI

preview_player
Показать описание
Published on 18 Sep 2023:
In this video, we will learn to merge two data sets in power query editor. Think of this as joining two or more tables for those of us who come from the SQL world.
This is a denormalisation step. Just because we can merge queries does not mean we should merge queries.
There are valida scenarios we need to do this.

In the previous video, we learnt to pivot and transpose data in Power Query editor in Power BI.
When we converted row values to column headers, pivoting data removed duplicate rows.
When we convert row values to column headers, transposing does not remove duplicate rows.

SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel,SQL Server and Python!!

Our Playists:

ABOUT DAGDOO:
Website:

Questions? Comments and SUGESTIONS? You will find me here:

Twitter: @dagdooe

Category: Science & Technology
License: Standard YouTube License
Рекомендации по теме
Комментарии
Автор

By creating a merged query, this means if there's an update in one of the dataset, that same merged query isn't updated?

youngthecreator