Forum Discussion

rachellek's avatar
rachellek
Frequent Visitor
5 years ago

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 ...