In Matrix, I need measure to show last value if calculation is blank

[jsauber]

I have a matrix visual displaying item numbers as rows and dates as columns.

The dates are from autocalendar() so that I capture every day.

The source data does not have transactions every day.

Where there are no measure results, the matrix is blank.

All calculations are working as intended.

What I need is to show the last calculated value if, for the day, there were no results.

Matrix:

Measure:

1.01 Inventory Position =

VAR CurrentItem = SELECTEDVALUE(Combined[MaterialLookup])

VAR CurrentDate = SELECTEDVALUE(Combined[UsageDate])

RETURN

CALCULATE(

    SUM(Combined[UsageQty]),

    FILTER(

        ALL(Combined),

        Combined[MaterialLookup] = CurrentItem &&

        Combined[UsageDate] <= CurrentDate))

[amitchandak · Accepted solution]

@jsauber , Prefer date table, Example to show last available value

calculate(lastnonblankvalue(Table[Date], [Meausre]), filter(all(Date), Date[Date] <= Max(date[Date]) ) )

DAX functions: lastnonblankvalue , firstnonblankvalue: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=26940s

[jsauber]

 Thank you so much. This worked. The video was also very useful, thank you for including it.