Forum Discussion
Solved
Matrix with Blank Values
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...
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 )
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
)
works great! thx for the help!