- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Comparing two Lists: ListCurrentEE, and ListFillers: and extract
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

it may more readable to rewrite the code like this
Table.AddColumn(PreviousStepName,"Result",(RowRecord)=>List.Select(RowRecord[Current EE],(Item_In_CurrentEE_List)=> List.Contains(RowRecord[Fillers],Item_In_CurrentEE_List,(Item_In_Fillers_List,Item_In_CurrentEE_List)=>Text.Contains(Item_In_CurrentEE_List,Item_In_Fillers_List))))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hello wdx223_Daniel,
Thank you for your correct help, your prompness and explanation.
From the first answer, you solve it. The detailed explanation I will try to understand it in reference with the funtions arguments.
You are very helpful. Thanks
DSR
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

=Table.AddColumn(PreviousStepName,"Result",each List.Select([Current EE],each List.Contains([Fillers],_,(x,y)=>Text.Contains(y,x))))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hello wdx223_Daniel,
1- Thank you very much,
2- Yes you solve it for me. It works.
Q- May you please explain for me in plain English what each Item ("[Filters]", "_", " "y" and "x" ) in List.Contains([Fillers],_, and in Text.Contains(y,x) refer to inside List.Select([Current EE], or to Outside the Table[Column] and to which Lists "Filters or "Current EE"?
I wanted to to give Kudos and Accept as solution now, but I am afraid if I click Kudos and accept now, No one after that will read the Q and answer me to understand how it works, So I decided to wait a little bit.
Thank you wdx223_Daniel,
DSR
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

it may more readable to rewrite the code like this
Table.AddColumn(PreviousStepName,"Result",(RowRecord)=>List.Select(RowRecord[Current EE],(Item_In_CurrentEE_List)=> List.Contains(RowRecord[Fillers],Item_In_CurrentEE_List,(Item_In_Fillers_List,Item_In_CurrentEE_List)=>Text.Contains(Item_In_CurrentEE_List,Item_In_Fillers_List))))

Helpful resources
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
09-07-2021 12:54 AM | |||
11-30-2019 03:52 PM | |||
Anonymous
| 04-13-2021 06:56 AM | ||
06-15-2022 11:45 PM | |||
02-11-2025 06:39 AM |