Forum Discussion

JGARROD's avatar
JGARROD
Helper I
3 years ago
Solved

Filter a table by a parameter

Hi,    I have a table which is being profilied, as such another table has been created which does a number of thing such as count distinct, distributon of value etc for all columns of the underlyin...
Need Help
  • ToddChitt's avatar
    ToddChitt
    3 years ago

    I have never tried this so just guessing here:

    Add a derived column in Power Query and concatenate the Status column with the literal ", Both" so now that column contains values like "Active, Both" or "Inactive, Both". Filter on that column with a CONTAINS comparison against the Parameter value. 

    This may fail depending on if the comparison engine thinks that "Active" is CONTAINED in "Inactive, Both" even though it is a capital A versus a small a. But I *think* Power Query is CASE Sensitive.

    Try it and let us know how it goes.

ToddChitt's avatar
ToddChitt
Super User
3 years ago

I have never tried this so just guessing here:

Add a derived column in Power Query and concatenate the Status column with the literal ", Both" so now that column contains values like "Active, Both" or "Inactive, Both". Filter on that column with a CONTAINS comparison against the Parameter value. 

This may fail depending on if the comparison engine thinks that "Active" is CONTAINED in "Inactive, Both" even though it is a capital A versus a small a. But I *think* Power Query is CASE Sensitive.

Try it and let us know how it goes.