Forum Discussion

siva_powerbi's avatar
siva_powerbi
Helper IV
5 years ago
Solved

Error while using the concatenated string to filter multiple columns

Hello Experts   I have a requirement to filter the table over multiple columns and the conditon is filter columns are dynamic and are passed through parameter input.    Concatenated the input wit...
Need Help
Show and Tell
Tips and Tricks
  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

    sel = Expression.Evaluate("Table.SelectRows(Bottomrows, each "&KeepString&"))",
    [Table.SelectRows=Table.SelectRows, Bottomrows=Bottomrows, KeepString=KeepString, Logical.FromText=Logical.FromText])

smpa01's avatar
smpa01
Community Champion
5 years ago

siva_powerbi  Looks like this might be the bug

 

 

 

p = "[#"""&extract{0}&"""]"&" = "& extract{1},

 

 

 

 can't have " before record [ and and after record ] too

p=[........]

siva_powerbi's avatar
siva_powerbi
Helper IV
5 years ago

Thanks for the answer but issue got resolved.