Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Jimb2007
Regular Visitor

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.

 

Jimb2007_0-1621894552637.png

 

Totaly frustrated and need help in a bad way, please.

1 ACCEPTED SOLUTION
v-deddai1-msft
Community Support
Community Support

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:

 

Capture.PNG

 

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

View solution in original post

5 REPLIES 5
v-deddai1-msft
Community Support
Community Support

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:

 

Capture.PNG

 

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
Continued Contributor
Continued Contributor

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

Still getting this error.

 

Jimb2007_0-1621899192776.png

 

Hi,

This works fine for me.  See the 2 images.

Untitled.png

 

Untitled1.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi @Jimb2007

 

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

It will make it easier to provide the solution.

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).
chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.