Forum Discussion

mr_guedes's avatar
mr_guedes
Helper I
8 years ago

Previous Month Value when Blanks

Hi everyone.   I have this table where I have every item purchased from 2016 until today. Every now and then there is a item that I don't buy every month, so I want to fill the blank with the value...
Need Help
Tips and Tricks
v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi mr_guedes

Assume your table is like 

Then put it in a matrix visual,

What you want, for example, for item a, when the value for one month is blank, it should be filled with the value of the last month's.

 

Does my assumption above describe what you dataset is or what your expect result should be?

 

If not, please share me how you table structure and which columns or measures you add to the matrix, what expected result should be.

 

Best Regards

Maggie

 

 

 

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    8 years ago

    Hi mr_guedes

    I test with your pbix, but i find it is difficult to show as you expected, it can't be done in the original table, i struggle to create a new table with multiple data, this would increase the size of pbix and slow the performance. 

     

    Best Regards

    Maggie

    • mr_guedes's avatar
      mr_guedes
      Helper I
      7 years ago

      So.. there is no way out then?