Forum Discussion

Jimb2007's avatar
Jimb2007
Regular Visitor
5 years ago
Solved

Expression.Error

Anyone know how to fix this Expression.Error below?  I was trying to get help on adding a number of days to the current date to give me an Out of Stock Date.     Totaly frustrated and need h...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Jimb2007 ,

     

    Did you contains FinalStep step in your query? The error means that you don't have FinalStep steps or table in your query. As normal, Table.addColumn used to use the last step as input like:

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

Nishantjain's avatar
Nishantjain
Continued Contributor
5 years ago

Hey, 

 

It seems your expression is completely wrong. You have multiple Table.AddColumns in your formula which isn't right. I think you only need need one of them

 

Try

 

= Table.AddColumn(FinalStep, "Out of Stock Date", each Date.AddDays([Current Date], [DaysonHand]))

 

Nishant

Jimb2007's avatar
Jimb2007
Regular Visitor
5 years ago

Still getting this error.

 

 

  • KNP's avatar
    KNP
    Super User
    5 years ago

    Hi Jimb2007, 

     

    Are you able to share all of the code from the advanced editor?

    It will make it easier to provide the solution.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    This works fine for me.  See the 2 images.