Forum Discussion

BIXL's avatar
BIXL
Resolver I
9 years ago

convert sql "in" statement to power query filter code

Hi all,

I have a sql statment that has where clouse that uses the "in" statement that has a large number of elements in it

like :

select col1,col2 

fromTABLE X

where  col1 in ('abc','aaaa',ddd,'zxs','q','w'.......and so on).

 

I am looking for an easy smart way to convet this into power query single filter command.

 

Thanks

 

1 Reply

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    BIXL

     

    You can try with following power query in Advance Editor of PBI Desktop.

    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each [col1] = "abc" or [col1] = "aaaa" or [col1] = "ddd" or [col1] = "zxs" or [col1] = "q" or [col1] = "w")

     

    Best Regards,

    Herbert