Forum Discussion
Add values at missing dates
I had a quick look at the file. There are relationships. If you delete them or make them inactive i believe it works (the resulting table has then around 7 million rows)
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Try creating a new table (Table2 is the second one you show):
TableRes =
GENERATE (
Table2;
GENERATESERIES (
CALCULATE ( DISTINCT ( Table2[Date] ) );
VAR Current_ =
CALCULATE ( DISTINCT ( Table2[Date] ) )
VAR Next_ =
CALCULATE (
MIN ( Table2[Date] );
Table2[Date] > Current_;
ALL ( Table2[StockQty] )
)
RETURN
IF ( NOT ISBLANK ( Next_ ); Next_ - 1; Current_ )
)
)
You'll have the actual date column in "Value". Delete the column 'Date' and rename Value as Date. All this would probably be more elegant in M.
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Thanks a lot AlB,
I think this is getting in the right direction, but so far the new table looks almost the same as the original table.
I have selected one PartID and this is how it looked in the original table:
Table: PartIDStockHistory
In the newly created table the same selection looks like this:
Table: TableRes