Forum Discussion
filter rows from custom query based on a filter condition
How to filter a rows from a query(appended from 2 queries) in query editor based on a condition similar to the following DAX in M language:
=RELATED(Employee[ID])
Hi Anonymous,
RELATED() function returns a single value that is related to the current row. How do you want to filter rows via RELATED? Do you combine two tables via "Merge" in Query Editor? And you only want to get rows that are RELATED from two tables, right? If so, please click the EmployeeID fileds and choose "Inner Join" in the drop down list.
Best regards,
Yuliana Gu
2 Replies
Hi Anonymous,
RELATED() function returns a single value that is related to the current row. How do you want to filter rows via RELATED? Do you combine two tables via "Merge" in Query Editor? And you only want to get rows that are RELATED from two tables, right? If so, please click the EmployeeID fileds and choose "Inner Join" in the drop down list.
Best regards,
Yuliana Gu