Get first and last record

[_matheuswesley]

can anybody help me?

I have two tables in my app.

I need the first value of “saldo_inicial” and the last “saldo_atual” result from the table “apostas_matheus” where “mes” and “ano” are equal to the “lucro_mensal” table (“mes” and “ano”).
I will subtract both to get my monthly profit

And would this be the best way? Thank you very much

[Steve · Accepted solution]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

How do I get a column value from the last row of this thing only? LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) ), "My Table", "_ROWNUMBER", "Wanted Column" ) Replace My Table with the name of the table from which you want the column value; Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID); and Wanted Column with the name of the column whose value you want. See also: MAX()

[_matheuswesley]

Mr. Steve!

Thank you very much!

On target, exactly what I needed.

thank you very much again.