Forum Discussion

guilhem's avatar
guilhem
Frequent Visitor
9 years ago
Solved

how to join tables

Hello,   I have the following tables I would like to make a new table as per follows     select    Issue ID   Unit Name   Cap   Date From   Sheet1 join Sheet2, Sheet3 Where   (Shee...
  • guilhem's avatar
    guilhem
    9 years ago

    I finally got the solution ...

     

    Make a new table ...

    Table = Filter( Crossjoin ( table A, TableB ), cond1&&cond2&&cond3....)

     

     

    And it works ... 

     

dkay84_PowerBI's avatar
dkay84_PowerBI
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

This is all done in the query editor.  Are you familiar with this part of Power BI (Get and Transform, formerly Power Query, in Excel)?

guilhem's avatar
guilhem
Frequent Visitor
9 years ago

I finally got the solution ...

 

Make a new table ...

Table = Filter( Crossjoin ( table A, TableB ), cond1&&cond2&&cond3....)

 

 

And it works ...