I have “Harvest_Schedule” table like this, i create a "PRE-HARVEST DATE" as a virtual column and i want to get date, when i harvest that product last. And fill “PRE-HARVEST DATE” with that previous date.
KEY………PRODUCT………HARVEST DATE……_…_PRE-HARVEST DATE(Virtual column)
1_________Tomato__________01/05/2021________________null
2_________Banana__________05/05/2021________________null
3_________Tomato__________06/05/2021____________01/05/2021
4_________Tomato__________15/08/2021____________06/05/2021
5_________Banana__________20/05/2021____________05/05/2021
…
i try to do with MAXROW() and i get a error with that code;
MAXROW("Harvest_Schedule", "HARVEST DATE", ([PRODUCT]<[_THISROW].[PRODUCT]))
Would you please help me.
LinkedIn
Twitter
