Forum Discussion

jayendra's avatar
jayendra
Frequent Visitor
9 years ago
Solved

using join condition and how to get the multiple columns

HI

 

 

I have two table 1 is project  and it contains projectkey column and the 2 table is getissues and that has projectkey column.i dont know which join condition is used.But in get issues table 5 columns is their i want that 5 columns  and project table conatins 4 columns and i want that 4 columns.how to create a query in Power Bi (or) is their any dax forumuls.can you provide me ASAP or any links

 

Regards

jayendra

Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago
    jayendra wrote:

    HI

     

     

    I have two table 1 is project  and it contains projectkey column and the 2 table is getissues and that has projectkey column.i dont know which join condition is used.But in get issues table 5 columns is their i want that 5 columns  and project table conatins 4 columns and i want that 4 columns.how to create a query in Power Bi (or) is their any dax forumuls.can you provide me ASAP or any links

     

    Regards

    jayendra

    jayendra

    You can just create a proper one:many relationship for those two tables. Then just drag columns from those two tables to visuals, the data would be linked automatically. For tables in relationship, you could also reference function RELATEDTABLE and RELATED

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi jayendra

     

    Try the LOOKUPVALUE() DAX formula. 

     

    You go to the table, where you want all your data, and you look up the values, you need, in order to perform your calculations.

  • Eric_Zhang's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago
    jayendra wrote:

    HI

     

     

    I have two table 1 is project  and it contains projectkey column and the 2 table is getissues and that has projectkey column.i dont know which join condition is used.But in get issues table 5 columns is their i want that 5 columns  and project table conatins 4 columns and i want that 4 columns.how to create a query in Power Bi (or) is their any dax forumuls.can you provide me ASAP or any links

     

    Regards

    jayendra

    jayendra

    You can just create a proper one:many relationship for those two tables. Then just drag columns from those two tables to visuals, the data would be linked automatically. For tables in relationship, you could also reference function RELATEDTABLE and RELATED