Hello!
Thanks for sharing your use-case. Since the values you need to display are not connected to sequential dates, the PREV function will not work here. This function with the syntax you created could take only the previous day for the specific date and not the most recent day within the row.
In your case, it looks like you need to choose the value for the most recent date available for a specific Asset.
I recommend you to explore the following solutions and threads that might help to achieve your goal:
Calculating Values For The Most Recent Date
Choose the latest date available in a dashboard filter
Best Regards, Lily
