Solved: Copy data From above Row - Page 2

Amit_Jain1 · 03-25-2019 05:44 AM

What will be formula to IF column X Contains Value Yes then copy Data from above Row

Steve

Replace TRUE in the inner SELECT() with an expression to limit the list of row numbers to only those below this row’s (([_ROWNUMBER] < [_THISROW].[_ROWNUMBER])😞

IFS(
  ([ColumnX] = "Yes"),
  ANY(
    SELECT(
      TableName[Date],
      [_ROWNUMBER]
      = MAX(
        SELECT(
          TableName[_ROWNUMBER],
          ([_ROWNUMBER] < [_THISROW].[_ROWNUMBER])
        )
      )
    )
  )
)

or, equivalently:

IFS(
  ([ColumnX] = "Yes"),
  LOOKUP(
    MAX(
      SELECT(
        TableName[_ROWNUMBER],
        ([_ROWNUMBER] < [_THISROW].[_ROWNUMBER])
      )
    ),
    "TableName",
    "_ROWNUMBER",
    "Date"
  )
)

View solution in original post