Forum Discussion
Solved
Using List.Contains causing long load time
Ok...let me see if I can explain this and get some help. I've got static data in an external excel sheet. I've loaded that into power query, then Transformed a column to Convert to List and named ...
In each table/query where you use the list, add a step up front that buffers your list with
BufferedList = List.Buffer(InServiceXIDs)
Then use BufferedList in place of InServiceXIDs in your later query step(s). Also, you don't need to have "=true" after List.Contains.
Pat
Try this:
(List.Contains(List.Buffer(InServiceXIDs_List),[unit_id])=true))"
--Nate
ppm1
Solution Sage
Solution SageIn each table/query where you use the list, add a step up front that buffers your list with
BufferedList = List.Buffer(InServiceXIDs)
Then use BufferedList in place of InServiceXIDs in your later query step(s). Also, you don't need to have "=true" after List.Contains.
Pat
worked like magic, thanks