Forum Discussion

Backpacker4Life's avatar
Backpacker4Life
Frequent Visitor
3 years ago

Create measure for most recent value – dynamic

Hi, I’m trying to figure out a DAX solution to use the most recent value for future dates that are blank. The fact table looks something like this: Date Item ID Total Sold 1/31/2020 ...