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 Pr...
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)))

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

    Thanks, it works.

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

    Resolved by creating a custom column in query editor. Thanks