convert sql "in" statement to power query filter code

[BIXL]

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

[v-haibl-msft]

@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