Forum Discussion
Replace empty values in a matrix with the previous non blank value
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
Hello tamerj1 , Thank you for the answer ,However the measure still shows the same results as what I had before ( for your info I replaced Mesure with the max of the total number I had in the column)
Community ChampionAnonymous
Would you please place the dax that you have used.
Measure = MAXX (
TOPN (
1,
FILTER (
ADDCOLUMNS (
FILTER ( ALLSELECTED ( 'kpi TotalErrorHistory'[Date]), 'kpi TotalErrorHistory'[Date]<= MAX ( 'kpi TotalErrorHistory'[Date] ) ),
"@Value",
VAR CurrentDate = 'kpi TotalErrorHistory'[Date]
RETURN
CALCULATE ( [Measure 2], 'kpi TotalErrorHistory'[Date] = CurrentDate )
),
[@Value] <> BLANK ()
),
'kpi TotalErrorHistory'[Date]
),
[@Value]
)- tamerj1
Anonymous
Please try
Measure2 =
MAXX (
TOPN (
1,
FILTER (
ALLSELECTED ( 'kpi TotalErrorHistory' ),
'kpi TotalErrorHistory'[Date] <= MAX ( 'kpi TotalErrorHistory'[Date] )
),
'kpi TotalErrorHistory'[Date]
),
'kpi TotalErrorHistory'[TotalNumber]
)