Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Roym
Helper IV
Helper IV

Power Query show columns if they match other table

I have currently two tables in my report, below a short example:

 

Table1:

With columns: Gap name, Linked to issue, status

 

Table2:

with colimns: Issue name, status

 

Now what I would like to do in power query is create a new table that shows all the columns from Table1, but only if the column 'Linked to issue'  has exactly the same value as 'Issue name'  in table2. Is that possible? I can filter with measures in the report itself but I would like to merge it at the source right away if possible

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

That will be an 'inner join'.  Left Outer means 'return all the rows from the left table with matching rows from right or null values'

View solution in original post

5 REPLIES 5
HotChilli
Super User
Super User

That will be an 'inner join'.  Left Outer means 'return all the rows from the left table with matching rows from right or null values'

Yes perfect! Thanks! This was easlier then expected, my brain was just not connecting the right dots this time haha

HotChilli
Super User
Super User

This is the exact reason that Merge Queries exists.

That is what I thought as well, but I think I miss something. So when creating a new merged query like below I would like to see all the columns of table 'Issues' only when the Number/Name is the same as in the other table. But when I do it this way I just get a table with all the records of the first table, nothing is filtered.

 

Capture.PNG

I solved it partially, there was a space at the end of the name in 'linked to created ic issue' so now it shows in this merge editor the correct amount of matches. Only when creating the newly merged table it still shows everything., not only the rows that match

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors