Forum Discussion

vgeldbr's avatar
vgeldbr
Helper IV
6 years ago
Solved

Using a variable as an operator in a Power BI query filter

This may not be very elegant but would appreciate some help to find a solution.   I have set up a Parameter (SubPortfolio Filter) to filter a query based on the values in a column. I have another P...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago
    Hi vgeldbr

    This should work
    Table.SelectRows(dbo_VW_PPM_ExportFinancial_FY20, each List.Contains(PortfolioFilterList, [Portfolio]) and fComparerList(SubPortfolioFilterList, [SubPortfolio], if SubPortfolioFilterType then "=" else "<>"))

    Kind regards
    JB
Anonymous's avatar
Anonymous
Not applicable
6 years ago
Hi vgeldbr

This should work
Table.SelectRows(dbo_VW_PPM_ExportFinancial_FY20, each List.Contains(PortfolioFilterList, [Portfolio]) and fComparerList(SubPortfolioFilterList, [SubPortfolio], if SubPortfolioFilterType then "=" else "<>"))

Kind regards
JB
vgeldbr's avatar
vgeldbr
Helper IV
6 years ago

Anonymous  thanks for all of your help. You've provided me with all the pieces I needed to achieve what I wanted!