Returning last entry in a database column
I have created a database that adds a new line against a date each day. From this I am building some metrics and then a dashboard which will show Daily Performance but also week to date, annual etc.
I am struggling to reference the database and return the last entry in a column. It seems that Lookup, Vlookup or Index should work but can't quite get there.
I have added a picture of the formula which seems to work in excel?
Any help out there appreciated.