Forum Discussion
Getting next date from dynamic indexing
Hello, In the below images, i'm trying to extract the datediff between some dates and then get a rolling sum of it, for every id. In the left table we have a date column sorted, which cor...
date_out=
MAXX (
FILTER (
ALLSELECTED ( wo_dates ),
COUNTROWS (
FILTER (
wo_dates,
wo_dates[date_in] < EARLIER ( wo_dates[date_in] )
&& wo_dates[dot_workorderid] = EARLIER (wo_dates[dot_workorderid] )
)
)
),wo_dates[date_in]
)Thank you for the reply. The specific formula returns the max date.