Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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))))
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
=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))))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
52 | |
21 | |
12 | |
11 |