Forum Discussion

mape's avatar
mape
Frequent Visitor
8 years ago

In a matrix, how I can replace values in empty cells with values of previous cells ?

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 ...
Abduvali's avatar
Abduvali
Icon for Skilled Sharer rankSkilled Sharer
8 years ago

Hi mape,

 

 

You can create a Column with IF statement in it like:

 

  • COLUMN = if(YourTable[Sales] = BLANK(), 0, SUM(YourTable[SALES])
  • and then use that column for to display sales this should solve having blank cells in a matrix

 

 

Regards

Abduvali

mape's avatar
mape
Frequent Visitor
8 years ago

Hi Abduvali, thanks for you quick response, in fact the result isn't as I expected. 

 

By default with the field "Sales" I have this  matrix:

 

 201520162017
    
Customer A        900,00 €    1.200,00 €    1.000,00 €
Customer B        700,00 €        500,00 € 

 

The new measure or calculated column that I want , it shows like this:

 

 201520162017
    
Customer A        900,00 €    1.200,00 €    1.000,00 €
Customer B        700,00 €        500,00 €        500,00 €

 

i.e., if cell is blank it could show the "last sales" in the previous just period

 

If you can give me another idea, thanks...

:)