The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
@Anonymous , have you tried lastnonblankvalue
https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak
@Anonymous , have you tried lastnonblankvalue
https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak
Lastnonblankvalue works perfectly, thank you!