meging two tables

[umairarshad]

Hello,

I am sorry if posted in the irelevent section.

I have two tables as below

Year	Station	Month	Eqpt	GSE ID	Total Consumption
2024-25	KHI	April	ACU	GD-147	306
2024-25	KHI	September	ACU	GD-147	414
2024-25	KHI	June	ACU	GD-147	743
2024-25	KHI	August	ACU	GD-147	247
2024-25	KHI	October	ACU	GD-147	550
2024-25	KHI	May	ACU	GD-147	687
2024-25	KHI	July	ACU	GD-147	905
2024-25	KHI	November	ACU	GD-147	240

and 

Year	Station	Month	Eqpt	GSE ID	Hrs
2024-25	KHI	April	ACU	GD-147	8
2024-25	KHI	August	ACU	GD-147	6
2024-25	KHI	October	ACU	GD-147	17
2024-25	KHI	September	ACU	GD-147	8
2024-25	KHI	June	ACU	GD-147	17
2024-25	KHI	May	ACU	GD-147	16
2024-25	KHI	July	ACU	GD-147	22
2024-25	KHI	November	ACU	GD-147	2

I want the result in such a way that hrs and Total Consumption columns should be side by side in power query.

Please help.

[PwerQueryKees · Accepted solution]

Use Merge Queries

Select all the columns you need to match each row with exactly one other row by ctrl-click.
Make sure the match column numbers align:

Then press OK and in the resulting column, select the Expansion Marker

And select the column you want to add to your table:

Did I answer your question? Then please mark my post as the solution and make it easier to find for others having a similar problem.
If I helped you, please click on the Thumbs Up to give Kudos.

Kees Stolker

A big fan of Power Query and Excel

[Omid_Motamedise]

Use Merge command

[v-achippa · Accepted solution]

Hi @umairarshad,

Thank you for reaching out to Microsoft Fabric Community.

To merge two tables and have the Hrs and Total Consumption columns side by side, please follow below approach:

• Open Power BI Desktop and load the two tables.
• Go to the Home tab and click Transform Data, this opens the Power Query Editor window

• Select the first table and click the Merge Queries drop down and then select Merge Queries as New

• A new window will open, from there select the first table in first dropdown and second table in the second drop down and then select any matching column from two tables for eg., Month and from the Join Kind select the Left Outer join and click OK like below

• A new Table will be created, from that table from the Hours column click on the Expand icon

• From the Expand area select only the Hrs column and click on OK

• The Hours will be displayed next to the Total Consumption column like below

• Rename the Table name and column name’s as per your requirement and from the Home Tab click on Close and Apply in the top-left corner of Power Query Editor.
• The combined table will now be available in your Power BI data model

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Thank and regards,

Anjan Kumar Chippa

[PwerQueryKees · Accepted solution]

Use Merge Queries

Select all the columns you need to match each row with exactly one other row by ctrl-click.
Make sure the match column numbers align:

Then press OK and in the resulting column, select the Expansion Marker

And select the column you want to add to your table:

Did I answer your question? Then please mark my post as the solution and make it easier to find for others having a similar problem.
If I helped you, please click on the Thumbs Up to give Kudos.

Kees Stolker

A big fan of Power Query and Excel

[umairarshad]

Great man. It worked. Thanks a lot.

[umairarshad]