Forum Discussion
Backpacker4Life
3 years agoFrequent Visitor
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 ...
FreemanZ
Super User
3 years agodo you have dates for other days besides month end days
Backpacker4Life
3 years agoFrequent Visitor
Hi FreemanZ, I do not. I have that column connected to a date dimension table though.