Forum Discussion
jbuck2020
Helper I
Helper INeed to automatically distribute values between dates
Hello, I have a query like this ID | Start | End | Duration | Amount The "Amount field" is actually supposed to be spread evenly between the start and end dates, with slightly more going...
sturlaws
Resident Rockstar
Resident Rockstarsorry, gave you the wrong code, try this instead:
jbuck2020Helper I
Helper IHoly smokes, I think that worked! Thank you so much, this is great.
- jbuck2020
Just one more question: If I were trying to add another column with like Day 1, Day 2, etc next to the column we just created what would that look like in power query?
- sturlaws
"Day " & Number.ToText(Duration.Days(Duration.From([Custom]-[start]))+1)
- jbuck2020
Any idea why I would get this error when I apply the query changes?
OLE DB or ODBC error: [Expression.Error] The Date operation failed because the resulting value falls outside the range of allowed values..