Reply
DSR
Resolver I
Resolver I
Partially syndicated - Outbound

Comparing two Lists: ListCurrentEE, and ListFillers: and extract

DSR_0-1686083190146.png

 

1 ACCEPTED SOLUTION

Syndicated - Outbound

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))))

View solution in original post

4 REPLIES 4
DSR
Resolver I
Resolver I

Syndicated - Outbound

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

wdx223_Daniel
Super User
Super User

Syndicated - Outbound

=Table.AddColumn(PreviousStepName,"Result",each List.Select([Current EE],each List.Contains([Fillers],_,(x,y)=>Text.Contains(y,x))))

Syndicated - Outbound

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

 

Syndicated - Outbound

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))))

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

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.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)