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 help in a bad way, please.

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

5 Replies

  • 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

      • 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.

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    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