Forum Discussion
Filter one table by another one table
Hi,
I checked data source and it's turned out document name in both spreasheets has different naming scheme, short and long, so for Power Bi there were completely different documents. My mistake, I missed it during initial data checking and I focused just on Power Bi. It was reason why filter didn't work
I think problem will be solved after change all names to one scheme
Community ChampionAnonymous Perhaps the easiest solution would be to use a Merge step to join your two queries into a single table?
Do you have a date table? Would really need to understand your data better. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.