Forum Discussion
Helper IPrevious 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 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!
5 Replies
v-juanli-msftCommunity Support
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
mr_guedesMaggie,
You couldn't be more right! I'm sorry for the trouble, the file is attached now.. can you help me?
- 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
- Mardin
Advocate IV
v-juanli-msft Can you please share how you achieve the solution in your example pictures?
