add missing months

in my raw data i have suppliers with the respective volume.

if a supplier makes sales in a month, a line with the corresponding month and year is written to my ro data. if this supplier does not make any sales in the following month, no one day is made.

My problem: I would like to write a line with a zero value in the month in which the supplier makes a one-day (see example in the appendix).

Date.xlsx (17.4 KB)

If you have furhter questions or sth. is not clear pls write me back.

Create a data range covering your periods (Create date time range node), then do ya cross join and fill missing values with zeros

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.