Calculate max non blank value on the last date

[Anonymous]

I have a really simple task and I have no idea why the formula doesn't work.

So there is a list of measurements that are done for several locations from time to time and I need to get the maximum measured value on the last available date.

I can't filter out blank values of the measurements in a table as there are several columns that are measured at different times.

A sample dataset is attached.

Can someone explain why I did not get the desired result with a simple FILTER inside the formula?

https://drive.google.com/file/d/1M4Oe9REDZ0xHq7gFVh2KimNXw4DIqadh/view?usp=sharing

[amitchandak · Accepted solution]

@Anonymous , have you tried lastnonblankvalue

https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak

[Anonymous]

Lastnonblankvalue works perfectly, thank you!