I am trying to create a time series which shows transactions for two different product categories.
Each category (Category A and Category B) needs to have transactions for each day of the year. Something like this:
I have read in the forum how to create consecutive dates using ‘row number’:
date(‘12/31/2020’) + days(this)
The issue is that it brings the date sequentially, but each day will only appear once, and with a random category assigned. Something like this:
Is there any way to achieve this?
Thanks a lot in advance!