Forum Discussion
In a matrix, How I can replace the empty values in cells for the value in previous period?
Hi everyone!! I need help about this... Measure of sales per year and in case there is no information for that year, show the sales of the previous year. That is, given a series of sales per ...
Hi mape,
If your blank records not actually exist in table, it is impossible to use if statement to find out it and replace it.
You need to create new table to add these missing records and combine with original records, then write measure on merged table to replace blank value to previous value.
BTW, it will be help if you provide some sample data.
Regards,
Xiaoxin Sheng