Power Query filter using If statement

[olliehunt]

Hi,

I'm trying to apply a parameter to a filter in my dataset to filter the country. I've got that working so the parameter set to 1 filters for country 1 etc.

Ideally I'd like to have a parameter value that selects all. For example, 1 is country 1, 2 is country 2, 3 is country 3 but 9999 clears the filter to allow all countries. I'm not sure of the syntax for putting an If statement in there. Something like:
Table.SelectRows(#Source, If COUNTRY = 9999 then nofilter Else each ([Country] = COUNTRY"))

Any ideas?

Thanks in advance!

 

[RoryA]

You should be able to do something like this:

Table.SelectRows(#Source, each (if COUNTRY = 9999 then true else [Country] = COUNTRY))

 

[olliehunt]

You should be able to do something like this:

Table.SelectRows(#Source, each (if COUNTRY = 9999 then true else [Country] = COUNTRY))

That worked a treat. Thanks!