cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TST_BY
Helper III
Helper III

Condition "or" in Advanced Editor (M)

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.

1 ACCEPTED SOLUTION
PC2790
Impactful Individual
Impactful Individual

Did you try:

 

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

 

It works for me

View solution in original post

1 REPLY 1
PC2790
Impactful Individual
Impactful Individual

Did you try:

 

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

 

It works for me

View solution in original post

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.