Expression.Error

[Jimb2007]

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.

[v-deddai1-msft · Accepted solution]

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]

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]

Still getting this error.

[Ashish_Mathur]

Hi,

This works fine for me.  See the 2 images.

[KNP]

Hi @Jimb2007, 

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

It will make it easier to provide the solution.