Forum Discussion

Schreckofant's avatar
Schreckofant
Regular Visitor
1 year ago
Solved

Dont Understand the Join

Hi , Im new in PowerBI an i have a problem I want to join two tables. The Product ID column is identical in both tables and contains almost 128 Product IDs, each of which is assigned 8 UserIDs and ...
Need Help
Tutorial Requests
  • dufoq3's avatar
    dufoq3
    1 year ago

    If you want to join them row by row (you have same 128 rows in each table and 8 rows per ID) you can add index to both tables and create such join with INDEX column.

dufoq3's avatar
dufoq3
Community Champion
1 year ago

If you want to join them row by row (you have same 128 rows in each table and 8 rows per ID) you can add index to both tables and create such join with INDEX column.

  • dufoq3's avatar
    dufoq3
    Community Champion
    1 year ago

    Hello again Schreckofant, you can even use this code. Create blank query, open Advanced editor and replace whole code with this one:

     

    let
    Source = Table.FromColumns(Table.ToColumns(UserID) & Table.ToColumns(ReviewID[[ReviewID]]), Value.Type(Table.FirstN(UserID,0) & Table.FirstN(ReviewID[[ReviewID]],0)))
in
    Source