Forum Discussion
Anonymous
4 years agoNot applicable
Adding missing date rows and filling in Quantity
Hi, I have a table INVENTORY which has Inv_Date and the respective Quantity, as follows; Inv_Date Quantity 01.01.2021 10 02.01.2021 10 05.01.2021 15 07.01.2021 ...
Anonymous
4 years agoNot applicable
One last question (sorry, I am still a DAX rookie, but learning). If I have multipe Component part numbers and Plants to account for in the data, like in the table below, how would I incorporate this into the query;
| Quantity | Component | Inv_Date | Plant |
| 72 | 605A | 19.08.2021 | US |
| 72 | 605A | 23.08.2021 | US |
| 0 | 120C | 19.08.2021 | China |
| 0 | 605B | 19.08.2021 | China |
| 10 | 120C | 23.08.2021 | China |
| 0 | 605B | 23.08.2021 | China |
| 10 | 120C | 24.08.2021 | China |
| 0 | 605B | 24.08.2021 | France |
| 0 | 120C | 30.08.2021 | France |
| 0 | 605B | 30.08.2021 | France |
AlexisOlson
4 years agoSuper User
If you have multiple rows per date, then this can't be done by adding columns to a date column with one row per date.
You could do a crossjoin of dates and components and then add columns but it might be better to stick to your original data table and use measures to fill the holes as needed rather than interpolating a complete crossjoin.