Filldown measure for each Id and last status is open
I have the “changes” table that stores Estimated and Real hour changes for each ID from when the project opens until it closes. I’m trying to create a measure that gives me the last value of that column for all days. The following measure provides the expected result, except for days when an ID has no entries but another ID does (for example, on 2024-02-10😞 Real_Filldown = VAR LastNonBlankDate = CALCULATE ( MAX ( changes[Date] ), FILTER ( ALLEXCEPT( changes , changes[Id]), changes[Date] <= MAX ( changes[Date] ) && changes[Real] <> 0 ) ) RETURN CALCULATE ( SUM ( changes[Real] ), FILTER ( ALLEXCEPT( changes , changes[Id] ), changes[Date] = LastNonBlankDate ) ) How can I modify this measure to get the last value of “Real” for days when that date doesn’t exist for a specific ID but does for another (for example, 2024-02-10)? Additionally, I’d like the “Real_Filldown” measure to only fill in data for days when the project is from “Open” to “Closed.” I attach my example files: https://easyupload.io/y2vf3y
