Forum Discussion
Maltaparis
1 year agoFrequent Visitor
Need help to fix my code
Dear all, I need your help I am getting crazy, in Powerquery, I created a calculated column but it doesnt worK All the column names are correct It keep stating there is a syntax error with "and" ...
- 1 year ago
There is no need for parentheses here after if .
But you are missing the reference to the outer scope.
each [MAT] = [MAT]will always evaluate to true and
and [Date] = [DateMax]doesn't know where to find [Date].
Show the entire code for that step if you want further help.
lbendlin
1 year agoSuper User
There is no need for parentheses here after if .
But you are missing the reference to the outer scope.
each [MAT] = [MAT]
will always evaluate to true and
and [Date] = [DateMax]
doesn't know where to find [Date].
Show the entire code for that step if you want further help.