Forum Discussion
Solved
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" ...
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.
Dear all,
First of all thank you very much for your heklp
To answer some of the question
My code is complete
I have so far a ingle Table called 'MS", with a column Date (in date format), I dont understand why the code is acting like it doesnt exist?
HI Maltaparis ,
I noticed that 'MS' appears in the first parameter of Table.SelectedRows.
Best Regards,
Bof