Skip to main content

Notifications

Power Up Program - Visualize data with Power BI
Unanswered

How to create table with many table

Posted on 14 Nov 2024 11:17:35 by 19
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 
Categories:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,151

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,845

Leaderboard

Featured topics