Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Calculate max non blank value on the last date

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

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User
2 REPLIES 2
amitchandak
Super User
Super User
Anonymous
Not applicable

Lastnonblankvalue works perfectly, thank you!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.