Forum Discussion
Error Expression.Error: We cannot convert the value false to type 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])
Yes i am Brazilian,
The [COLUMN] you said refering to what? Because i understand as i refere to a diffrent table i cant jus put the column name, isnt?Anonymous ,
Funções de lista recebem o primeiro parametro de lista, me parece que está colocando uma tabela. Por isso a estrutura
Table.SelectRows(Tabela.....)[COLUNA]... assim você força um retorno de lista.