using join condition and how to get the multiple columns

[jayendra]

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

[Eric_Zhang · Accepted solution]

---

@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

[Anonymous]

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.