How to create table with many table

[KRAYA]

Dear All,
I have many 4 table 
Table 1: 

Status	Link
Pending	Link 1
Due soon	Link1
Pending	Link 2
Pending	Link 3

Table 2: 

Status	Link
Pending	Link 10
Due soon	Link 5
Due soon	Link 6
Due soon	Link 7

Table 3:

Status	Link
Pending	Link 11
Due soon	Link 12
Due soon	Link 13
Due soon	Link 14
Due soon	Link 15
Pending	Link 16

Table 4

Status	Link
Correct	Link 11
Incorrect	Link 12
Correct	Link 13
Incorrect	Link 16

I need to club this all 4 table and make new table (Table 5) into power BI 
Table 5

Category	Status	Link to visit
Table 1	Status	Link
Table 1	Pending	Link 1
Table 1	Due soon	Link1
Table 1	Pending	Link 2
Table 1	Pending	Link 3
Table 2	Pending	Link 10
Table 2	Due soon	Link 5
Table 2	Due soon	Link 6
Table 2	Due soon	Link 7
Table 3	Pending	Link 11
Table 3	Due soon	Link 12
Table 3	Due soon	Link 13
Table 3	Due soon	Link 14
Table 3	Due soon	Link 15
Table 3	Pending	Link 16
Table 4	Correct	Link 11
Table 4	Incorrect	Link 12
Table 4	Correct	Link 13
Table 4	Incorrect	Link 16

I tried doing Function - Selectcolumn and Union but failed to get this .Can any one explain me how to do this 

[divyed]

Hello @KRAYA ,

Here is a simple dax for you :

Table5 =
UNION(
ADDCOLUMNS(Table1, "Category", "table1"),
ADDCOLUMNS(Table2, "Category", "table2"),
ADDCOLUMNS(Table3, "Category", "table3"),
ADDCOLUMNS(Table4, "Category", "table4")
)

I hope this helps.

Did I answer your query ? Mark this as solution if this helps or give a thumbs up.

Cheers

[Kedar_Pande · Accepted solution]

@KRAYA 

Create the new table

Table5 = 
UNION(
SELECTCOLUMNS(
Table1,
"Category", "Table 1",
"Status", Table1[Status],
"Link to visit", Table1[Link]
),
SELECTCOLUMNS(
Table2,
"Category", "Table 2",
"Status", Table2[Status],
"Link to visit", Table2[Link]
),
SELECTCOLUMNS(
Table3,
"Category", "Table 3",
"Status", Table3[Status],
"Link to visit", Table3[Link]
),
SELECTCOLUMNS(
Table4,
"Category", "Table 4",
"Status", Table4[Status],
"Link to visit", Table4[Link]
)
)

Give this a try and let me know if it works for you!

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn