Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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"
Solved! Go to Solution.
Nevermind..default feature is available