Matrix with Blank Values

[asebes]

My raw data doesn't always have values for every month.  So when displaying in a matrix format i'm getting "blank" data for months that are missing.  How can i build my measure so that if the data is blank for a given month it pulls in the value from the last month with a value.  For example Jun-21 is blank but i need to go back to Apr-21 to get a number.  

Thanks in advance for the help!

[Ashish_Mathur]

Hi,

See if my solution here helps - Show Balance outstanding everyday even if data for everyday is not available.

[jdbuchanan71 · Accepted solution]

@asebes 

Assuming you have a date table the measure would be along these lines

Measure = 
VAR _Date = MAX('Dates'[Date])
RETURN
    CALCULATE(
        LASTNONBLANKVALUE( Dates[Date], SUM ( 'Table'[Amount] ) )
        ,Dates[Date] <= _Date
    )

[asebes]

works great!  thx for the help!