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 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!
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 )
3 Replies
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!
Hi,
See if my solution here helps - Show Balance outstanding everyday even if data for everyday is not available.
