Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
Solved! Go to 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
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
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.
Hi,
This works fine for me. See the 2 images.
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 ;). |
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. | Proud to be a Super User! |
User | Count |
---|---|
141 | |
70 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |