Forum Discussion
List.Contains and List.Startswith
I have a question regarding a problem in power query M Lets say I have table A with multiple projet a-bc a-et, h-gf, c-df, a-2d, And I have a table B with project prefix a, d, c, I woul...
Hi Anonymous
Download sample PBIX file with solution code
Set up both tables and load into Power Query.
You can then filter the Projects table with the Prefix table with this line
= Table.SelectRows(Source, each List.ContainsAny(Text.ToList(Text.Start([Project],1)), Prefix[Prefix]))Regards
Phil
Hi Anonymous
Download sample PBIX file with solution code
Set up both tables and load into Power Query.
You can then filter the Projects table with the Prefix table with this line
= Table.SelectRows(Source, each List.ContainsAny(Text.ToList(Text.Start([Project],1)), Prefix[Prefix]))
Regards
Phil