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
Community ChampionAnonymous
Apologies for the late response. I got engaged with something else.
This has to be a dimension table. Create a new calculated table
Dates = ALLNOBLANKROW ( 'kpi TotalErrorHistory'[Date] )
create the relationship between the two tables. Place the new dimension date column in the columns of the matrix instead of tge original one. Tyen try the following measure in the values. Remember you can change the MAXX to SUMX based on your requirement.
Measure1 =
VAR SelectedTable =
ALLSELECTED ( 'kpi TotalErrorHistory' )
VAR CurrentDate =
MAX ( 'Dates'[Date] )
RETURN
MAXX (
VALUES ( 'kpi TotalErrorHistory'[KPIDescription] ),
SUMX (
TOPN (
1,
FILTER (
SelectedTable,
VAR KPIDesc = 'kpi TotalErrorHistory'[KPIDescription]
RETURN
'kpi TotalErrorHistory'[Date] <= CurrentDate
&& 'kpi TotalErrorHistory'[KPIDescription] = KPIDesc
),
'kpi TotalErrorHistory'[Date]
),
'kpi TotalErrorHistory'[TotalNumber]
)
)
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