Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello - like the title says, I have a SSAS Dax Query (Import) that I am trying to add a condition based on another list of values. These values are currently stored in an excel file. Right now, I'm importing all the rows of data (millions), then filtering the list down to the ~50k rows I need using the other query. Is it possible to use this list of values I need filtered on in the original query?
Solved! Go to Solution.
Apply List directly in your query, This works for me
let
Source = YourOtherDataSource,
FilteredRows = Table.SelectRows(Source, each List.Contains(MyList, [YourColumn]))
in
FilteredRows
Best Regards,
HSathwara
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ChrisFromOhio Yes, it's possible to filter the data in your query based on the list of values stored in your Excel file directly,
Follow the instructions in the ScreenCapture and let me know If it works for you or not
Thank you for the reply. How do I go about taking my list of values and converting that to a parameter, as this list can and will update from time to time.
Apply List directly in your query, This works for me
let
Source = YourOtherDataSource,
FilteredRows = Table.SelectRows(Source, each List.Contains(MyList, [YourColumn]))
in
FilteredRows
Best Regards,
HSathwara
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |