Pulling forward last entered value to date by date day

[Allisond]

Good Morning,

I have a Measure set up to pull forward the most recently entered value until a new value is entered. 

ID                Date                  Value

123             01/01/20            3
123             01/03/20            1
123             01/06/20            2

Result should look like this:

01/01/20     01/02      01/ 03       01/04      01/05    01/06      01/07

    3            3          1           1         1         2          2

I have set up my measure as:

Measure =

VAR FirstVisibleDate = MIN(Dates[DayDate])

VAR PreviousDate = CALCULATE(MAX(Table[Value Date]), Dates[DayDate]<=FirstVisibleDate)

VAR FilterPreviousDate = TREATAS({PreviousDate},Dates[DayDate])

VAR Result = CALCULATE([Latest Value],FilterPreviousDate)

RETURN

Result

[Latest Value Date] is a simple measure calculating the LastNonBlank

However, my result is only showing the latest dates appropriately.  My first values are blank.  

Actual Result: 

01/01/20      01/02       01/ 03       01/04      01/05     01/06      01/07

                                                              2           2

Can anyone else see what is wrong with my measure?   Thank you for any help!

[DataInsights · Accepted solution]

@Allisond,

Try this approach.

1. Create measure. Table2 is the data table, and has a relationship with Dates.

Latest Value = 
VAR vCurrentDate =
    MAX ( Dates[Date] )
VAR vMaxDateCurrentID =
    CALCULATE (
        MAX ( Table2[Date] ),
        ALLSELECTED ( Dates[Date] ),
        Table2[Date] <= vCurrentDate
    )
VAR vMaxValueCurrentID =
    CALCULATE (
        MAX ( Table2[Value] ),
        ALLSELECTED ( Dates[Date] ),
        Table2[Date] = vMaxDateCurrentID
    )
RETURN
    vMaxValueCurrentID

2. Create matrix visual and date slicer. Columns in matrix should be Dates[Date], and set to "Show items with no data".

Sample data:

[Allisond]

Thank you so much for looking at this!