Hi everyone,
I'm currently working with a revenue by customer dataset that includes three columns: customer name, date, and amount. I'm trying to create records with zero as the amount for months where we didn't have any business with a customer. My goal is to have a record for each customer for every month across the three-year dataset. I tried to use the generate rows tool, but it does not seem to be working.
Thank you!
@nakennedy
Any sample data for us?
@nakennedy
I generate every Month based on your minimum Month and Maximu Month of your dataset
Then join back to the original datastream, the ones are not matching are the ones we are looking for, I think.