Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
In Power BI, I'm trying to import a Star Schema source and it is a table#1 of 100% integer keys.
In order to limit the dataset I'm having to manually lookup all the key translations to user friendly names.
I want to retrieve only data for Location Key1 = 7729 . I may have a list of 100 keys to pull and do not want to manually create a M Step to filter each key.
Is the scenario below even possible:
I want to create a Table#2 that contains all the Key values I want to filter within Table#1.
Can I lookup values in Table#2 and use that within the M query to filter Table#1?
Solved! Go to Solution.
Absolutely. I would use the List.Contains() function here. Everything in List 1 would be filtered by List 2. This is all with in a Table.SelectRows (filter) step.
I do this so often I wrote a blog post showing you each step you need to take and explained it in full detail here: Using List.Contains To Filter Dimension Tables — ehansalytics
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingAbsolutely. I would use the List.Contains() function here. Everything in List 1 would be filtered by List 2. This is all with in a Table.SelectRows (filter) step.
I do this so often I wrote a blog post showing you each step you need to take and explained it in full detail here: Using List.Contains To Filter Dimension Tables — ehansalytics
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting