DAX query

[prashantg364]

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.

[wdx223_Daniel]

NewTable=GENERATE(VALUES(Table[Product Code]),CALENDAR(DATE(2023,3,1),DATE(2023,3,5)))

[prashantg364]

Resolved by creating a custom column in query editor. Thanks

[prashantg364]

Thanks, it works.

[aditya0125]

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.