Forum Discussion
rachellek
5 years agoFrequent Visitor
Measure showing latest non-empty value, when later, empty, dates exist
I'm trying to write a measure which shows the most recent non-empty value. My data looks like: Year Start Date Value Target 1/1/19 2 6 1/1/20 0 5 1/1/21 1 4 1/1/22 3 ...
Jos_Woolley
Solution Sage
5 years agoHi,
Shouldn't you just be using:
MyMeasure =
LASTNONBLANK ( 'Table'[Value], 1 )
Regards