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