Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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'
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
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.
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
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |