Forum Discussion
Fill in Missing End Dates in Table
I have a table where ever once in a while there is missing data on one of the date fields that calculates the production time of an item. Basically, I have a start date but sometimes I don't get an e...
Try this
Adj Date = IF( ISBLANK(Table[End Date]), VAR id = Table[ID] VAR order = Table[Order] VAR tbl = FILTER( Table, Table[ID] = id && Table[Order] > order ) RETURN IF(COUNTROWS(tbl) > 0, MINX(tbl, [Start Date]))
Thanks! Worked perfectly.
Thats great, how about thumbs up for that ;-)