Forum Discussion

Jimb2007's avatar
Jimb2007
Regular Visitor
5 years ago
Solved

Adding Days to current date

So i have a field that shows the number of days till out of inventory and I want to have it add to the current date so I know what the date is the inventory will run out.  Then I can compare the date...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    You could add a column. Say your last step name is FinalStep, and your days on hand field is DaysOnHand:

    CurrentDate= Date.From(DateTime.LocalNow()),
    NewColumn = Table.AddColumn(FinalStep,  "OutOfStockDate", each Date.AddDays(CurrentDate, [DaysOnHand]))

     

    This will add the amount of days from DaysOnHand to today's date.

    --Nate 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

You could add a column. Say your last step name is FinalStep, and your days on hand field is DaysOnHand:

CurrentDate= Date.From(DateTime.LocalNow()),
NewColumn = Table.AddColumn(FinalStep,  "OutOfStockDate", each Date.AddDays(CurrentDate, [DaysOnHand]))

 

This will add the amount of days from DaysOnHand to today's date.

--Nate 

Jimb2007's avatar
Jimb2007
Regular Visitor
5 years ago

So I have created to column "Current Date" but when I try your recommended solution to add to that colum the number of days til out I get an error.  Seems to be with FinalStep.  I do not understand why.  Is this just to name the column or to provide a calucalated function? What is the function of FinalStep?