topic Append 4 tables queries in DAX Commands and Tips

Append 4 tables queries

Anonymous — Sun, 15 Dec 2024 19:40:46 GMT

I have 4 tabels (BL, BL -1, sales, org)

Each table contain only one column named "Order number"

I want to create a new table in the PQ which contain one column that merging each column from the tabels,

I tried using append queries but I got the pic below which seems that he created 4 columns table and I want one column that merging the tabels, any ideas what to do?>

thx

Re: Append 4 tables queries

lbendlin — Sun, 15 Dec 2024 21:11:12 GMT

You don't seem to have a column "Order number".

I want to create a new table in the PQ which contain one column that merging each column from the tabels

Please elaborate what you mean by that.

Re: Append 4 tables queries

Anonymous — Sun, 15 Dec 2024 21:12:56 GMT

Sorry I meant "order line"

I want to take the 4 tabels and combain them into 1 table with 1 column.

Re: Append 4 tables queries

lbendlin — Sun, 15 Dec 2024 21:21:00 GMT

you will have to rename them before the append.

Re: Append 4 tables queries

v-aatheeque — Mon, 16 Dec 2024 09:06:22 GMT

Hi Anonymous ,
Thanks for reaching out to the Microsoft Fabric Community forum.
lbendlin Thanks for prompt response.
I have created a sample dataset as follows, based on your description :
Sheet 1:

Sheet 2:

Sheet 3 :

Sheet 4 :

NOTE : Replace Table1, Table2, etc., with the actual table names, and ColumnName with the relevant column names

The desired output after appending the tables is shown below:

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Re: Append 4 tables queries

Anonymous — Mon, 16 Dec 2024 09:15:00 GMT

Yes, thx all! I didnt know column names should be the same

thanks again !