cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: using join condition and how to get the multiple columns


@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

Capture.PNG

View solution in original post

2 REPLIES 2
Highlighted
Anonymous
Not applicable

Re: using join condition and how to get the multiple columns

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.

Highlighted
Microsoft
Microsoft

Re: using join condition and how to get the multiple columns


@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

Capture.PNG

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors