Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DSR
Helper I
Helper I

Comparing two Lists: ListCurrentEE, and ListFillers: and extract

DSR_0-1686083190146.png

 

1 ACCEPTED SOLUTION

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
Helper I
Helper I

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

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

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

 

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

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors