I have two tables - Sales and Dates Tables. I want the first date to come in front of the first 7 rows in sales data. Similarly the second date in front of the next 7 rows in Sales data.
Solved! Go to Solution.
Hi @MKanchwa , you can do it like this:
We use the generate rows tool to make 7 rows for each date. We can then join on record position to add the dates to the sales table. Hope this helps!
Thank you very much @FinnCharlton