Forum Discussion
Populating last months data for items with missing value
Hello, Can someone assist me. I attached a file of data below. Ultimately I am looking for the EOM balance for certain items where I can then break down the data by month afterwards. I have ma...
Update:
Thank you for your reply.
I created a crossjoined table for the items and all dates.
I understand the importance of the crossjoined table. With a date for each day for each item. In theory then all of the transactions would appear with each date = 0 for dates with no requirement.
But this is giving me very odd values for the AccumulatedOnDate column.
You can see the table on the left has the correct accumulated values but on the right the accumulated on date is so far off I don't understand it.
The dates and the DatetoUse are working but not exactly, for the item shown in the table snapshot there shouldn't be any values until aug 2022.
Can you help me pull the right data values for Accumulate on date?