I have incoming Excel workbooks that I receive monthly. Each workbook gives me one sheet that has columns for, [SKU, SHIP DATE (M/D/Y), and Qantity].
From this data I get how many SKUs are to ship in the provided upcoming months, usually extending out 9 months.
My problem is that I pull these workbooks in using <Get Data, From Folder> and if the prevous workbook had say 10 for 10/1/2024, 15 for 11/1/2024, 25 for 12/1/2024, 10 for 1/1/2025, then in the next received workbook the line for date 12/1/2024 is ommitted I cannot use my DAX measure that provides me with the LASTNONBLANK becuase it will still be looking at the older workbook amount of 25 for 12/1/2024.
There isn't a row that has 12/1/2024, Qty -. The row for that date is just left off the list.
If I input a zero by adding a +0 to the LASTNONBLANK measure this doesn't work.
In Power Query how can I add the missing row of data back into the list with a Zero QTY by using the start of the [SHIP DATE] and the last [SHIP DATE] provided (not all SKUs are missing a row of data, so I'm guarentied a Min and Max range)?
