Forum Discussion
Solved
Show only items with no data
I have a table with a list of files with its details, that has been sent to two different companies for being processed. Everyday, I receive a report of the files that should be processed before a s...
At the end I solved it creating a new table with a left outer join:
PowerQuery Editor > Home > Combine > Append Queries > Append Queries as new
Thank you anyway!
v-xicai
Community Support
Community SupportHi ebuckcherry ,
You can try to change the Cross filter direction of relationships between the tables from Single to Both, which will take them treated as a single table. Or could you please show me the detail content about the three tables or data model in screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.