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 ...
Tanushree_Kapse
Impactful Individual
5 years agoHi rachellek
You can sort the date... as descending and apply Is not blank filter on the value.
Thanks!