Expression.Error: We cannot apply field access to type Number

Question

Hello, I have two columns and if the value in the second column is in the first column, if it does not pass itself, if it contains values smaller than itself, if it contains values greater than itself, I want it to give the minimum value among the values larger than itself in the list, otherwise return null&nbsp;but when I create a condition like the following, I get a type error when I want to get the values in the list larger than the data in column B for List.Skip. I couldn't get past this part. What can be done instead.&nbsp;&nbsp;Table.AddColumn(TransformColumnTypes, "C", each if List.Contains(Expression.Evaluate("{"&amp;[A]&amp;"}"), [B] ) then [B] else if [B] &gt; List.Max(Expression.Evaluate("{"&amp;[A]&amp;"}"),1) then List.Min(Expression.Evaluate("{"&amp;[A]&amp;"}"),1) else if [B] &lt; List.Max(Expression.Evaluate("{"&amp;[A]&amp;"}"),1) then List.Min(List.Skip(Expression.Evaluate("{"&amp;[A]&amp;"}"), each _ &lt; [B])) else null )&nbsp;&nbsp;=&nbsp;&nbsp;

wdx223_daniel · Accepted Answer

List.Skip(Expression.Evaluate("{"&amp;[A]&amp;"}"), (x)=&gt;x &lt; [B])

Forum Discussion

Related content

Expression.Error: Access to the resource is forbidden.

Power BI Desktop - Expression.Error: Expression.Error: Access to the resource is forbidden

Error message : Expression.Error

Expression.Error

PowerBI dynamic OAUTH token using Entra App - Expression.Error: Access to the resource is forbidden.