Forum Discussion

xjiang's avatar
xjiang
Frequent Visitor
7 years ago
Solved

Issue with using information from both tables after creating relationship

Hello all,   I need some help for a project that I have been working on,   I have 2 tables (A: 40 columns with the planning stats) (B: 48 columns with the actual stats). Each table has more than ...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    7 years ago

    Hi xjiang - 

     

    In Query Editor when you do "Merge Queries", you can match up the 7 columns that align between the two tables and use a "Left Outer" join to get all of the rows and columns from the Planning table, and all of the columns from the Actuals table that match up with a row in Planning, like so:

     

     

    Hope this helps

    David

dedelman_clng's avatar
dedelman_clng
Community Champion
7 years ago

Did you try merging them together in PowerQuery (Query Editor) instead of in the model? Then you would only have one table to deal with.

xjiang's avatar
xjiang
Frequent Visitor
7 years ago

Hi,

 

Thanks for your response!

 

Both of my tables are from SQL server and I don't have permission to create an extra index column in SQL. There's no single column that is unique enough for me to merge them together.

 

Is it possible to create an extra index column using the combination of existing columns in power bi query editor?