Forum Discussion
Helper IICompare 2 Tables and filter in Query
Hi mahra-in ,
Have you solved your problems with the suggestion of jdbuchanan71?
By my tests with merging the table in query editor, we could get your desired output.
If you have solved the problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Super UserYou can use a measure to limit the rows returned from Table2.
RowCount =
CALCULATE (
COUNTROWS(Table1),
INTERSECT(
VALUES(Table1[Project No]),
VALUES(Table2[Project No])
)
)Then you can add it to the table visual or use it as a filter on the visual.
mahra-inHi jdbuchanan71
Thanks for you reply.
I dont want in the visual. I want to limit the rows in Power Query Editor itself if not least at Report filter
Because after limiting rows in Table 1 based on Table 2, I need to develop various visuals using Table 1
- jdbuchanan71
Ahh, in power query you can do that using an innner join from table1 to table2. This will return only the rows that are in both.
v-piga-msftResident Rockstar
Hi mahra-in ,
Have you solved your problems with the suggestion of jdbuchanan71?
By my tests with merging the table in query editor, we could get your desired output.
If you have solved the problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry