Previous Month Value when Blanks

[mr_guedes]

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 from the last purchase that happened (when is the case). Now I've tried everything from IF to LASTNONBLANK, FIRSTNONBLANK, CALCULATE and variations and I don't know what to do anymore. I'll appreciate a lot any help!!

*All data is in only one table!

[v-juanli-msft]

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

[Mardin]

@v-juanli-msft  Can you please share how you achieve the solution in your example pictures?

[mr_guedes]

Maggie,

You couldn't be more right! I'm sorry for the trouble, the file is attached now.. can you help me?

https://1drv.ms/u/s!Ap4ZqNuvEs43tj0IfZHlRHEJmf_X

[v-juanli-msft]

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]

So.. there is no way out then?