We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
I have a product code table as shown below
Product code |
alpha |
beta |
gama |
x
Now I want to add a date column against each product for a specific duration, as example shown below
Product code | Date |
alpha | 01-Mar-23 |
alpha | 02-Mar-23 |
alpha | 03-Mar-23 |
alpha | 04-Mar-23 |
alpha | 05-Mar-23 |
beta | 01-Mar-23 |
beta | 02-Mar-23 |
beta | 03-Mar-23 |
beta | 04-Mar-23 |
beta | 05-Mar-23 |
gama | 01-Mar-23 |
gama | 02-Mar-23 |
gama | 03-Mar-23 |
gama | 04-Mar-23 |
gama | 05-Mar-23 |
Pls help me on creating a column.
NewTable=GENERATE(VALUES(Table[Product Code]),CALENDAR(DATE(2023,3,1),DATE(2023,3,5)))
Resolved by creating a custom column in query editor. Thanks
Thanks, it works.
Create date column manually in Query editor.
Get data-select Blank Query-type= {Number.From(#date(2023,1,1))..Number.From(#date(2023,3,15))}
and covert the ABC123 type to date.
User | Count |
---|---|
13 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
28 | |
20 | |
14 | |
11 | |
5 |