- 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
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 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 |
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
9 | |
7 | |
6 |