I have two table: Table A for registering new water ponds, and Table B which registers water level over time for different ponds.
I need the Deck view for Table A to show a VC with the last water level registry.
So I can see at a glance what´s the water level of that particular waterpond.
The two problems I´m facing:
- I cannot use [WaterLevel] as a Key as it does not have Unique values. So MAXROW() didn´t work for me.
- I would need to add a condition so that the water level matches each pond.
I solved problem #1 with this formula:
LOOKUP( MAX(Table B[_ROWNUMBER]), “Table B”, “_ROWNUMBER”, “WaterLevel” )
This way its showing the last “WaterLevel” for all ponds.
Im still missing the condition so that the “Ponds” match between “Table A” and “Table B”. Any ideas on how to add this?
Thanks for reading!