Forum Discussion
Rows left out from data source
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 ...
Hi RobRayborn ,
As a workaround, you can create a date table to fill in the missing dates with a quantity of 0. Here’s a step-by-step guide to achieve this:
1.Create a list of all dates within the range: Refer to Create Calendar Table Using Power Query M Language (mssqltips.com)
2.Merge the list of dates with your data: Merge this list with your existing data to ensure every date within the range is represented.
3.Fill missing dates with zero quantity: Replace any missing quantities with 0.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.