Lookup with two conditions

[Luis_Rodriguez]

I have a table to report fuel sale in 6 pumps, and 3 types of fuel for each pump; how can I put the previous reading of the number of gallons sold as the initial value, having two conditions, the number of the pump and the type of fuel?, The columns are: id, date, pump number, fuel type, current reading, previous reading. Thank you for your answers

[Steve]

help.appsheet.com

SELECT()

Gather column values from row in table or slice

help.appsheet.com

AND()

Are all true?

[Luis_Rodriguez]

Thanks Steve, I still haven’t been able to find the expression that helps me get the last value (147,001) of pump 3, diesel, could you help me?!

Captura de Pantalla 2021-02-16 a la(s) 13.48.43|416x500

[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()

[Luis_Rodriguez]

Thank you very much Steve, it works perfectly.