Forum Discussion
Error Expression.Error: We cannot convert the value false to type Function."
Hello to All, I am having a problem with a code to return a value based in multiple criteria, comparing multiple columns in two different tables. I have the error message after I run the code. ...
Hi Anonymous ,
Try changing this:
Table.SelectRows(relevantT, FtJump[JumpProtocol] >= Scores[ScoreValue])
by:
Table.SelectRows(relevantT, each FtJump[JumpProtocol] >= Scores[ScoreValue])
Insert the each keyword in every Table.SelectRows function.
Many Thanks camargos88
I just insert the EACH in all the Table.SelectRows functions.
But now the error has changed.
Expression.Error: We cannot convert a value of type Table to type List.
Why is that?Hi Anonymous ,
Can you share a sample of your pbix ? So I can take a closer look.
Anonymous ,
Are you brazilian ?
Check this code:
List.MinN(Table.SelectRows(relevantT, each Scores[ScorePercent] = 100),Scores[ScoreValue])
It should be something like:
List.MinN(Table.SelectRows(relevantT, each Scores[ScorePercent] = 100)[COLUMN],Scores[ScoreValue])