Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Replace empty values in a matrix with the previous non blank value

Hello , I have this matrix that shows the total number of differenet counts , I need to replace empty values with the previous total as shown in the screens :        Thank you in advance...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Thanks @tamerj1  for the answer. It unfortnathly didn't show the expected result .

    I finally created Date.WeekOfYear column and the totals were grouped accordinaly , so no emty values were left

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous 

please try

NewMeasure =
MAXX (
TOPN (
1,
FILTER (
ADDCOLUMNS (
FILTER ( ALLSELECTED ( 'Table'[Date] ), 'Table'[Date] <= MAX ( 'Table'[Date] ) ),
"@Value",
VAR CurrentDate = 'Table'[Date]
RETURN
CALCULATE ( [Measure], 'Table'[Date] = CurrentDate )
),
[@Value] <> BLANK ()
),
'Table'[Date]
),
[@Value]
)