Forum Discussion

BIXL's avatar
BIXL
Icon for Resolver I rankResolver 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,'...
v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft 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