Forum Discussion
Load only rows where a value exists...
I have two tables, opportunities and accounts.
In opportunities, each row has a value for account ID. I only want to load rows from the accounts table where the account ID already exists. In qlik, I would:
Load *
Where exists (account ID)
from xxxxxxx
I'm not sure how to do this in power BI however!
Thanks in advance!
3 Replies
darentengmfsPost Prodigy
Anonymous
What is your data source?
- Fowmy
Super User
Anonymous
You need to use the Merge feature in Power Query to create a left-out comparison and filter the column.________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Hi Anonymous ,
Has your problem be solved?
Merge queries feature should help. For more details please check the video.
https://www.youtube.com/watch?v=dTdFt9AvDHA
Best Regards,
Jay
