Good day, I’m trying to make the final value of the “final balance” column the suggested the initial balance" column, but I can’t do it. I copied what STEVE recommended to another user, but I’m definitely doing something wrong, I don’t quite understand those list errors…
LOOKUP(MAX(SELECT( P2P Diario[ RowNumber]. [_THISROW]. [Balance Final] = [Balance Final] ))), “P2P Diario”, “ROWNUMBER”, “Balance inicial”)
Error: The expression is valid but its result type Decimal is not one of the expected types: List
