Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
hi, I have had this problem a few times and don't really understand it,
If I define an custom list; ;
let alist = {"a acc a", "abc def", "abc dd dda", "abc a bc" } in alist
and then a custom funciton ;
( listA, valueA )=>
List.Contains( listA, valueA, ( x ,y )=>
Text.Contains( x, y ) )
i can invoke that on the list so ; Source = function; Source (Alist, "a") - = true ,
but if I want to use the custom function dialog box that is generated I cannot refer to the list, it is not recognesed,
I have to convert to a table , then define the list parameter as a list , I can then select the table / table column to use as a list?
this seems a very odd so
let alist = {"a acc a", "abc def", "abc dd dda", "abc a bc" } in
Table.FromList( alist, Splitter.SplitByNothing(), {"A"} )
( listA as list , valueA as text )=>
List.Contains( listA, valueA, ( x ,y )=>
Text.Contains( x, y ) )
Can anyone explain why I cant' just refer to the list directly ? or suggest other ways around this problem?
Richars
Solved! Go to Solution.
Just an ommision in the UI. If it is important to you, have a search. I recall something similar passing here, but can't find it myself... It can be worked around, but some effort is involved...
Thanks I just wondered if overlooking somthing obvoious, thanks for taking the time to resond.
Just an ommision in the UI. If it is important to you, have a search. I recall something similar passing here, but can't find it myself... It can be worked around, but some effort is involved...
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
8 | |
6 | |
6 | |
5 | |
5 |
User | Count |
---|---|
9 | |
9 | |
8 | |
6 | |
6 |