Condition "or" in Advanced Editor (M)

[Anonymous]

Hi all,

I'm currently working on a Query in PowerBI. A condition I want to create is to grab all files that end with ".xlsx" OR ".XLSX"

I tried this: 

Documents= Table.SelectRows(Source, each [Extension] = ".XLSX" or ".xlsx")

but it doesn't work as desired. Please note: I need both, simply changing the ending of the data will probably lead to problems in the future.

Just adding another line with "Documents" in the Advanced Editor doesn't work as well, Documents can only be used once.

[PC2790 · Accepted solution]

Did you try:

Documents= Table.SelectRows(Source, each [Extension] = ".XLSX" or [Extension] = ".xlsx")

It works for me