Forum Discussion
Look up date based on cumulative data
Hi I am struggling to get this to work. Essentially the data is in A and B. I want to input the date into Date Grazed and show under Date Ready where the cumulative data in B when taken from t...
A 365 solution using some accumulation:
=LET(
Accumulate, LAMBDA(a, v, a + v),
start, XMATCH(DateInput, Table1[Date]) - 1,
table, DROP(Table1, start),
dates, TAKE(table, , 1),
KgDM_Day, TAKE(table, , -1),
ReadyDate, SCAN(0, KgDM_Day, Accumulate),
XLOOKUP(GrowthRequired, ReadyDate, dates, " - ", 1)
)Patrick2788 Impresssive, but a bit over the top for such a trivial problem IMHO.
- Maybe so but it was fun!
