Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 the inventory will run out to the date the on order items will arrive to determine if I have an inventory gap or not. How do I do this. Been reading a ton of message boards and can't find a way to make this work. Please help.
Solved! Go to Solution.
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
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
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?
Hi, @Jimb2007
Could you please consdier sharing more details about it or a simple sample file without any sesentive information for further discussion?
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can use TODAY() in DAX columns/measures or Date.From(DateTime.LocalNow()) in the query editor to get the current date to add to your column. If it's a measure, you need to use the TODAY() approach.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |