Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
curiouspbix0
Helper IV
Helper IV

Power Query LIKE Query

Hi PQ geeks,

How do I write the filtered rows filter to pick all files starting with "ABC_" ? More of a like function.

 

 

let
Source = SharePoint.Files("https:XYZ", [ApiVersion = 15]),
#"Sorted Rows" = Table.Sort(Source,{{"Name", Order.Descending}}),
#"Filtered Rows" = Table.SelectRows(#"Sorted Rows", each ([Name] = "ABC_01022019.xlsx" or [Name] = "ABC_01022019.xlsx" or [Name] = "ABC_01032019" or [Name] = "ABC_01042019.xlsx"))
in
#"Filtered Rows"

1 ACCEPTED SOLUTION
curiouspbix0
Helper IV
Helper IV

Nevermind..default feature is available 

View solution in original post

1 REPLY 1
curiouspbix0
Helper IV
Helper IV

Nevermind..default feature is available 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors