Exemple:
Table1:
Date | Account | Last Value |
1/31/21 | Check | $5.00 |
2/02/21 | Saving | $6.00 |
2/03/21 | Other | $7.00 |
2/04/21 | Check | $12.00 |
Table2
Account | Last Value | 10 Days Change |
Check | $12.00 | ???? |
Saving | ||
Other |
Hello, I try to find the formulas for my 10 days change. I want to find the value of approx 10 days.
My formulas based on the example above:
=FINDROW(Table1, "Table2[Account]=Table1[Account] AND Table1[Date] < Today()-10"`)
My formula work, but it's show the DATE and a link to the row. I just want the [Last Value] Cell.
What Can I do?