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.
Hi,
I am trying to filter a column of item ID's by those found in a column in another table. I used the following M code to filter:
= Table.SelectRows(#"Renamed Columns2", each List.Contains(#"Forecast"[Item ID],[Master Item ID List]))
This seems to filter the existing "master item ID list" column appropriately, but then my file runs incredibly slow. Applying any changes from this query takes like 10 minutes, whereas before this step it was 10 seconds. I tried adding "Table.Buffer" to my source line in the advanced editor. Any other thoughts to speed this up? Should I be filtering a different way?
Hi V,
I do have a relationship established between each table and a "master table" that has all possible item ID's. So think of each table as having a subset of those ID's. When I'm trying to create visuals, I need to filter by the smaller of the two datasets, or I get a bunch of blanks and other errant data in the visual.
Is there another way to accomplish this without filtering the larger table by the smaller table in query editor?
Have you tried doing the filtering in the source, before loading the table?
Help when you know. Ask when you don't!
I don't want to filter the source itself, as it may be a fluid task that I don't want to constantly keep updating. At first, I was hopeful that I could simply filter via the visualizations in the desktop, but nothing worked. Filtering in the query editor gets me the right visuals, it just takes a long time to load.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |