Forum Discussion

Maltaparis's avatar
Maltaparis
Frequent Visitor
1 year ago
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" ...
Need Help
  • lbendlin's avatar
    lbendlin
    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.

Maltaparis's avatar
Maltaparis
Frequent Visitor
1 year ago

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?

lbendlin's avatar
lbendlin
Super User
1 year ago
My code is complete

If that were the case you wouldn't have the errors. 

I dont understand why the code is acting like it doesnt exist?

That's not the problem.  You need to reference the individual steps in your process, and you need to take special care of nested scopes.

I have so far a single Table called 'MS"

That's the name of the final output.  Each applied step has a different name.

 

Please show the entire code.