Forum Discussion

ChrisFromOhio's avatar
ChrisFromOhio
Icon for Helper I rankHelper I
2 years ago
Solved

Filter 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...
  • HarshSathwara19's avatar
    HarshSathwara19
    2 years ago

    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.

     

HarshSathwara19's avatar
HarshSathwara19
Icon for Helper I rankHelper I
2 years ago

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

 

  • ChrisFromOhio's avatar
    ChrisFromOhio
    Icon for Helper I rankHelper I
    2 years ago

    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.

    • HarshSathwara19's avatar
      HarshSathwara19
      Icon for Helper I rankHelper I
      2 years ago

      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.