Forum Discussion
ChrisFromOhio
Helper I
Helper IFilter SSAS Dax Query based on List of Values
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 i...
Apply List directly in your query, This works for me
let Source = YourOtherDataSource, FilteredRows = Table.SelectRows(Source, each List.Contains(MyList, [YourColumn])) in FilteredRowsBest Regards,
HSathwara
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ChrisFromOhioHelper I
Helper IThank 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.
HarshSathwara19Helper I
Helper IApply 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.