Forum Discussion

prashantg364's avatar
prashantg364
Icon for Helper II rankHelper II
3 years ago

DAX query

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 codeDate
alpha01-Mar-23
alpha02-Mar-23
alpha03-Mar-23
alpha04-Mar-23
alpha05-Mar-23
beta01-Mar-23
beta02-Mar-23
beta03-Mar-23
beta04-Mar-23
beta05-Mar-23
gama01-Mar-23
gama02-Mar-23
gama03-Mar-23
gama04-Mar-23
gama05-Mar-23


Pls help me on creating a column.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion
    3 years ago

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