How to create table with many table

Question

Dear All,I have many 4 table&nbsp;Table 1:&nbsp;Status&nbsp;LinkPendingLink 1Due soonLink1PendingLink 2PendingLink 3Table 2:&nbsp;Status&nbsp;LinkPendingLink 10Due soonLink 5Due soonLink 6Due soonLink 7Table 3:Status&nbsp;LinkPendingLink 11Due soonLink 12Due soonLink 13Due soonLink 14Due soonLink 15PendingLink 16Table 4Status&nbsp;LinkCorrectLink 11IncorrectLink 12CorrectLink 13IncorrectLink 16I need to club this all 4 table and make new table (Table 5) into power BI&nbsp;Table 5CategoryStatus&nbsp;Link to visitTable 1Status&nbsp;LinkTable 1PendingLink 1Table 1Due soonLink1Table 1PendingLink 2Table 1PendingLink 3Table 2PendingLink 10Table 2Due soonLink 5Table 2Due soonLink 6Table 2Due soonLink 7Table 3PendingLink 11Table 3Due soonLink 12Table 3Due soonLink 13Table 3Due soonLink 14Table 3Due soonLink 15Table 3PendingLink 16Table 4CorrectLink 11Table 4IncorrectLink 12Table 4CorrectLink 13Table 4IncorrectLink 16I tried doing Function - Selectcolumn and Union but failed to get this .Can any one explain me how to do this&nbsp;

kedar_pande · Accepted Answer

KRAYA&nbsp;Create the new tableTable5 = 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!&nbsp;💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉Cheers,KedarConnect on LinkedIn

Forum Discussion

How to create table with many table

2 Replies

Related content

Lakehouse Table Generate Create Table

Create new table

Create rows from 2 tables

Creating Date Tables

Matrix table

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

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

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