Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I need, in PowerQuery, create a step to filter a by field ( JOB) Table (CGJOBS (2) using a list already created (realocList).
Thanks
Solved! Go to Solution.
You first need to convert your list to table, then use Merge Queries transformation, and select Inner Join as the join type on the two columns
You first need to convert your list to table, then use Merge Queries transformation, and select Inner Join as the join type on the two columns
yes and no... that's not a filter by at query time but a merge. If we want to only keep 10 items out of millions of rows this method would require to first download the 10M rows to then only merge 10.
Filter by list would imply using Table.SelectRows and be able to refer a list of values.
Why didn´t I think that? Sometimes we are so determined to a specific type of solution we became blind.
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |