Nesting #Filtered Rows in an IF statement?

[JimiH]

Hello

I have a parameter setup that filters a number of quieries & charts I have setup.

Parameter Values are = "All,1,2,3,4,5,6,7,8,9,10,11"

Now the numerical values work fine but I also want to filter by 'All' the numbers also.

I'm thinking if I could have a nested query something like the following ,obviously the formatting would be different 🙂

let
    Source = Sql.Database("server1", "APro"),
    dbo_OEE_FOR_BI = Source{[Schema="dbo",Item="OEE_FOR_BI"]}[Data],

IF LineNumberPar = (1-11) then filter like the below

    #"Filtered Rows" = Table.SelectRows(dbo_OEE_FOR_BI, each [LocId]=LineNumberPar)

Else

Include all the records from Item="OEE_FOR_BI

in
    #"Filtered Rows"

Is that the right track?

Regards

Geoff

[v-caliao-msft · Accepted solution]

@JimiH,

In your scenario, you want to do it in your Power query, right? Actually, this requirement can be done by using Slicer easily. We can turn on Select All option.

Besides, here is a blog about IF statement in Power query for you reference.
http://www.excelguru.ca/blog/2014/08/27/the-if-function-in-power-query/

Regards,

Charlie Liao

[JimiH]

Right ok ,maybe I over think things

Cheers